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 “wrists” with Change Limit: [1] [2]

(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
wrists9541564(None) 
grists74716481grists
waists97415451waists
whists124613811whists
wists86728521w_ists
wrests95313081wrests
wrist84827561wrist_
wristy12509701wristy
writs86624381wri_ts
agists75713172agists
aorists74215832aorists
arises65233802arises
arista6415292arista
aristas7413522aristas
aristo6414032aristo
aristos7312372aristos
artists74215592artists
aurists74615782aurists
brises84927612brises
brisks124611402brisks
briss75824272bris_s
brits76433082bri_ts
britts84813442britts
cists76624532_cists
crests85218702crests
crises84529432crises
crisis83716342crisis
crisps104411512crisps
crista8311802crista
crits75527572cri_ts
crusts84916542crusts
deists74916432deists
drifts10499892drifts
exists134710912exists
feists94915312feists
firsts95110922firsts
fists85527542_fists
foists95413982foists
frises94124272frises
frisks13479262frisks
frits86129102fri_ts
fritts94613192fritts
frosts94214622frosts
gists66026192_gists
grifts104511682grifts
griots74713642griots
grist65529872grist_
grits65529582gri_ts
heists96814632heists
hists86328372_hists
hoists95516022hoists
irises64221172irises
joists134711032joists
jurists14409122jurists
kists95822112_kists
krises105016082krises
lists56628692_lists
lyrists1036962lyrists
maists85817572maists
mists76633902_mists
odists749852odists
prests84021262prests
priests93810862priests
prints84320102prints
prises84133172prises
prisms104915502prisms
priss74623892pris_s
purists94014072purists
rests54935872_rests
rifts85718642_rifts
riots54922012_riots
rises55244042_rises
risks94917062_risks
risus54216392_risus
rusts55026992_rusts
shists96515112shists
triste63818642triste
trusts64714432trusts
trysts9448792trysts
twists9549752twists
verists103613672verists
waist86132382waist_
waits88333522wai_ts
wasts87433672w_asts
wests85727002w_ests
whishts16425312whishts
whisks16497352whisks
whist115322952whist_
whits115923822whi_ts
wilts85023502w_ilts
wises85633192w_ises
wisps105214182w_isps
wiss75630542w_is_s
wist78049292w_ist_
wits76044872w_i_ts
worsts96014332worsts
wrest84925432wrest_
wricks154610622wricks
wries85827742wri_es
wriest94419712wriest_
wrights14318992wrights
wrings104012972wrings
writ75537912wri_t_
write85522832wri_te
writes94420332writes
wursts95211162wursts

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511062.51332849.6
3Display Results1061060.0462304.3
 (SQL Overall)1786911062.90261575.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.