Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “throaty” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
throaty1342848(None) 
throat94819751throat_
throats104612191throats
thready14435902thready
threat95020462threat_
threats104311672threats
thrifty1634192thrifty
throated1247922throated
throatily1543702throatily
treaty94414352t_reaty
trouty95211792t_routy
christy1536623christy
chromate15312783chromate
chromy16309903chro_my
chronaxy2343253chronaxy
croaky15528483_croaky
floaty124210943_floaty
frosty124710633_frosty
ghosty13467213gh_osty
groat65531973_groat_
groats74816653_groats
grotty10389833_grotty
grouty104710983_grouty
hoagy124710473_h_oagy
hoary114516763_h_oary
hooty115022443_h_ooty
horary12310383_horary
phorate12413363phorate
phratry1543743phr_atry
rooty86423023__rooty
shoaly124010773sh_oaly
shoat85633953sh_oat_
shoats94117083sh_oats
shorty124313203sh_orty
tarot55943933taro_t_
tarots66422993taro_ts
tarty86328183tar__ty
ternary1038343ternary
ternate7415483ternate
that75639323th__at_
thecate123210023thecate
theory121098363theo_ry
therapy1536613therapy
thereat104315243thereat_
thionate11137503thionate
thirsty1354083thirsty
thirty12378403th_irty
thorax1638253thora_x
thorite10313443thorite
thorny12509843th_orny
thrall93810293thr_all
thrash12258363thr_ash
thrave126010273thr_ave
thraw1110515923thr_a_w
thrawn12769423thr_awn
thraws129211103thr_aws
thread105011093threa_d
threads11419953threads
threap11569663threa_p
threaps12488643threaps
threated1259203threated
threaten1146303threaten
thrift12412043thrift_
thrifts1335523thrifts
thro77726423thro___
throatier1244553throatier
throating1398403throating
throb109816853thro__b
throbs118311373thro_bs
throe89321423thro__e
throes97518673thro_es
thrombi14134473thrombi
throne98517603thro_ne
throned115412173throned
thrones105715843thrones
throng10539973thro_ng
throngs11508163throngs
throstle1175703throstle
throttle1164083throttle
through141647513through
throve128012393thro_ve
throw118719733thro__w
throwaway2151313throwaway
thrower1386993thrower
thrown1214911443thro_wn
throws129715233thro_ws
thrummy1742173thrummy
thrust91911893thrust_
thrusts10226523thrusts
thruway1643163thruway
toady96814343t__oady
toasty9509563t__oasty
torosity1147243torosity
torot56139943toro_t_
toroth95512963toro_th
tray77632593t_r_a_y
treat56240353t_reat_
treats64821693t_reats
troak95213573t_roa_k
troaks104410603t_roaks
trolly94012363t_rolly
trophy1438283t_rophy
trot46351313t_ro_t_
troth85622203t_ro_th
trots56629943t_ro_ts
trotyl9236673t_ro_tyl
trout57332573t_rout_
trouts66116633t_routs
trowth1277883t_rowth
troy77429683t_ro__y
trusty94710113t_rusty
turbary1236383turbary

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.580308087.9
2DLD Change Limit1340271126.89019452.4
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.51623774.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.