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

127 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
athirst103787(None) 
thirst9312251_thirst
achiest12315192achiest
ashiest10313962ashiest
atheist10314062atheist
lathiest11312662lathiest
thirsts1036242_thirsts
thirsty1354082_thirsty
abhors11410623abhors_
accurst1146243accurst
achiral12109183achiral
adhibit1345343adhibit
aeriest73924053aeriest
aethers103614943aethers_
against838383against
ageist7315383agei_st
aghast105711373agh_ast
agist66325583a_gi_st
ahimsa1134783a_himsa
ahis76135383a_hi_s_
ahorse9311513a_horse
airest63825263a__irest
airiest74221013airiest
airs46447423a__irs_
airt45757783a__ir_t
airts55626343a__irts
alist56136783a_li_st
altoist7313393altoi_st
amidst94913233a_midst
amirs75924923a_mirs_
amorist9317643amorist
anthers103715203anthers_
antirust8411173antirust
antsiest8511463antsiest
aorist64827873aori_st
aphids125110843aphids_
aphis105917133aphi_s_
aphorist13412513aphorist
artiest73121993artiest
artist64125543arti_st
artsiest879653artsiest
assist6314603assi_st
atavist10311093atavist
atheism1248523atheism
atheists1138713atheists
athwart1348683athwart
atilt54828473at_i_lt
atomist92915763atomist
attars64515313attars_
attest62618613at_test
atticist10811343atticist
attics84413283attics_
attire62412383attir_e
attired8238913attired
attires72312953attires
attrit6315753at_trit
attrits7310613attrits
aurist65027253auri_st
authors10311853authors_
autist64324943auti_st
awhirl1264673awhir_l
bathers124720363bathers_
battiest104115553battiest
catchiest1638313catchiest
cattiest103016333cattiest
dashiest12311123dashiest
earthiest1259103earthiest
ethers94518413ethers_
ethicist1347893ethicist
ethics11169283ethics_
fathers133916503fathers_
fattiest113514313fattiest
first86226123__first
gathers114315073gathers_
heathiest1549393heathiest
hist76551543__hi_st
horst85833513__horst
hurst85527193__hurst
itchiest1336523itchiest
lathers104321883lathers_
lathis95516173lathi_s_
matiest92522453mat_iest
mothiest13311033mothiest
mythiest1636033mythiest
nattiest83215353nattiest
naturist8410813naturist
others93918003others_
patchiest1638353patchiest
pithiest132711443pithiest
rattiest83516113rattiest
satirist8313503sat_irist
schist11312653schi_st
shiest95821533_shiest
shirt84533903_shir_t
shirts94918343_shirts
shist84829613_shi_st
stairs65416333stairs_
stirs55921623st_irs_
tachist12613293tachi_st
tahrs85412333tah_rs_
tanist6324593tani_st
tapirs84113173tapirs_
tattiest83415383tattiest
theirs94610353_theirs_
theist9314763_theist
thins85826333_thins_
thir76420543_thir__
thiram1139963_thiram
third95912493_thir_d
thirds10438603_thirds
thirl85416823_thir_l
thirls95012063_thirls
thirsted1235213_thirsted
thirster1135673_thirster
thirty12378403_thirty
this76027383_thi_s_
thrift12412043_thrift
thrust91911893_thrust
thyrse1235133_thyrse
thyrsi1234453_thyrsi
twist86820983_twi_st
washiest14310413washiest
whilst1239143_whilst
whirs115218093_whirs_
whist115322953_whi_st
withiest142411243withiest
wrathiest1536983wrathiest

Search took 7 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 Limit1340271276.37321030.4
3Display Results1271270.0502540.0
 (SQL Overall)1786911276.84626101.5
 
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.