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 “thrifty” 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.

106 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
thrifty163419(None) 
thrift12412041thrift_
thrifts1335521thrifts
christy1536622christy
drifty13418222_drifty
shifty15409262sh_ifty
shrift12413542shrift_
shrifts1335962shrifts
thirsty1354082thirsty
thirty12378402th_irty
thriftily1842002thriftily
throaty13428482throaty
unthrifty1881722unthrifty
adrift10313113adrift_
aerify122810113aerif_y
charity15311023chari_ty
chitty14329433ch_itty
crafty14478913_crafty
drafty13638933_drafty
drift95722843_drift_
drifts10499893_drifts
etherify1744443etherif_y
ferity122813343feri_ty
fifty145211423__fifty
grift95924463_grift_
grifts104511683_grifts
gritty10338403_gritty
hefty146112133_h_efty
nifty115211633__nifty
parity114719873pari_ty
purify14399153purif_y
purity114114913puri_ty
rarify123210063rarif_y
rarity93615493rari_ty
rift75642333__rift_
rifts85718643__rifts
shift114225143sh_ift_
shifts124412943sh_ifts
shirty124312563sh_irty
shitty124110063sh_itty
shrieky17364803shrieky
shrilly13318563shrilly
shrimpy17415403shrimpy
tariff12711363tarif_f
tariffs1334593tariffs
tarty86328183tar__ty
terrify1336353terrif_y
theft114118133th_eft_
thefts12387923th_efts
theist9314763theist_
theists1039153theists
thinly1238673th_inly
thirdly1444633thirdly
thirst9312253thirst_
thirsts1036243thirsts
thistly1395963th_istly
thorite10313443thori_te
thready14435903thready
threat95020463threat_
threats104311673threats
thrice114311573thri_ce
thriftier1542853thriftier
thrill94910593thri_ll
thrills10398783thrills
thrip103012183thri__p
thrips11299013thri_ps
thrive125313223thri_ve
thrived14458183thrived
thriven13447023thriven
thriver13479123thriver
thrives134611713thrives
throat94819753throat_
throats104612193throats
thrummy1742173thrummy
thrust91911893thrust_
thrusts10226523thrusts
thruway1643163thruway
thurifer1443273thurifer
titty85316653t__itty
torrify1335013torrif_y
touristy1144513touristy
treaty94414353t_reaty
tricky154211473t_ricky
trifid1039063t_rifid
trifle94012883t_rifle
trigly103810943t_rigly
trilby1144973t_rilby
trimly114410893t_rimly
trinity10310843t_rinity
triply114211023t_riply
trippy13457803t_rippy
triste63818643t_riste
trite54730033t_ri_te
trouty95211793t_routy
trusty94710113t_rusty
tufty114810413t__ufty
turfy114315403tur_f_y
turista737443turista
twisty12426863t_wisty
typify1734523typif_y
variety1337743variety
verify153110163verif_y
verity123714853veri_ty
whity145513473wh_i_ty
wifty144212093__wifty
wristy12509703_wristy

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.423422437.4
2DLD Change Limit1340271066.70319995.1
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.17224915.1
 
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.