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

111 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
auntliest93632(None) 
antsiest8511462a_ntsiest
aunties73920072aunt_ies_
auntlier834902auntlie_r
jauntiest1635492jaunt_iest
jungliest1744922jungliest
runtiest83014512runt_iest
saintliest1046012saintliest
angriest9310253a_ngriest
annalist8413753annali_st
antileft1149993a_ntileft
artiest73121993a_rt_iest
artsiest879653a_rtsiest
auldest839893au__ldest
auntie64317703aunt_ie__
auntlike1234983auntli_ke
austerest948653austerest
autist64324943au_t_i_st
bubbliest1254423bubbliest
bulliest104314503bu_lliest
bunchiest1635663bunchiest
buntlines11207153buntlines_
burbliest1365593burbliest
burliest103113063bu_rliest
bustiest102815053bust_iest
costliest1138563costliest
courtliest1244903courtliest
cuddliest1343333cuddliest
curliest102713123cu_rliest
daintiest1039153daint_iest
dangliest1137173dangliest
dauntless1033663dauntl_ess
dungiest102810743dun_giest
dustiest93015073dust_iest
faultiest1236093fault_iest
featliest1238363featliest
flauntiest1343773flaunt_iest
funkiest152810973fun_kiest
funniest113010733fun_niest
fustiest113014573fust_iest
gainliest1037133gain_liest
gangliest1137673gangliest
gauntest936603gaunt__est
gauntlet955903gauntl_e_t
gauntlets1042873gauntl_ets
gauntries1046033gauntries_
gentlest93410573gentl_est
guiltiest1035713guiltiest
gunkiest132610573gun_kiest
gustiest92914523gust_iest
gutsiest92610583gu_tsiest
guttiest92311223gu_ttiest
hungriest1344543hungriest
hunkiest153812333hun_kiest
jangliest1746383jangliest
jingliest1735973jingliest
junkiest192610173jun_kiest
kindliest1436113kindliest
kingliest1436523kingliest
knurliest1344073knurliest
lintiest82715913lint_iest
loneliest949443loneliest
luniest73516993lun__iest
lustiest82914493lust_iest
manliest102314943man_liest
mintiest103217143mint_iest
motliest10310773_motliest
mustiest103017533must_iest
nettliest945413nettliest
nubbliest1354363nubbliest
nutsiest82710243nu_tsiest
nuttiest82312143nu_ttiest
outlies72421993ou_tlies_
paintiest11310563paint_iest
paunchiest1743853paunchiest
portliest11310183portliest
puddliest1343693puddliest
punchiest1636453punchiest
puniest92918093pun__iest
punkiest149312663pun_kiest
punniest102511583pun_niest
punties94520783punt_ies_
purtiest102414113purt_iest
raunchiest1543933raunchiest
rubbliest1354693rubbliest
ruffliest1554493ruffliest
ruliest72816433ru__liest
rumpliest1345313rumpliest
runniest82911203run_niest
rustiest83116803rust_iest
ruttiest82712663ru_ttiest
subtilest1148813subtilest
subtlest10511363subtl_est
sultriest938653sultriest
sunniest82712913sun_niest
surliest82416913su_rliest
tangliest1068423tangliest
tentiest82115613tent_iest
tingliest1047683tingliest
tinkliest1336133tinkliest
tuftiest1138283tuft_iest
ugliest8410153_u_gliest
unblest9411813_unbl_est
unholiest1246303_unholiest
unruliest945873_unruliest
untidiest1046033_untidiest
unties64326923_unt_ies_
untruest847783_untruest
untwist1047713_untwi_st
vaultiest1234833vault_iest
wintriest1238153wintriest

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411117.43619989.4
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.63823395.0
 
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.