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

116 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
nutcases108579(None) 
nutcase975761nutcase_
cutlases1038032cutlases
mutases92012042mut_ases
notecases1145172notecases
nutates73214972nut_ates
outcastes11118902outcastes
outcasts10108682outcasts
suitcases1144452suitcases
uncases93516552_uncases
anatases839793anat_ases
atlases72410643_atlases
autocades1246793autocades
butanes9312743but_anes
butches144315363butc_hes
carcases12313093carcases
cases75048383___cases
cupcakes1843713cupcakes
cuscuses1235863cuscuses
cutches143216463cutc_hes
cutises94414913cut_ises
cutlass938013cutlas_s
cutlasses1145103cutlasses
cuttages11297223cuttages
cycases1437533_cycases
discases112014503discases
ectases92911673ect_ases
encases93116053_encases
entases72816273ent_ases
euclases1039223euclases
fracases1336993fracases
fucoses12148303fu_coses
fucuses12158353fu_cuses
furcates1339883furcates
guanases936233guanases
hotcakes1744703hotcakes
hutches153613523hutc_hes
incases93615973_incases
inulases838763inu_lases
judases1534443ju_dases
lactases1038523lactases
mucuses11148513mu_cuses
mutase82811993mut_ase_
mutates92215793mut_ates
mutches143314283mutc_hes
narcoses103910543narcoses
nautches1336083nautc_hes
nictates1039593nictates
nitchies1339073nitchies
nitrates82516223nitrates
notates72817483not_ates
notches123513653notc_hes
notecase1044823notecase_
nucleases1146493nucleases
nuncles939843nunc_les
nurses63919353nu__rses
nutate63017373nut_ate_
nutated83113423nut_ated
nutgalls943953nutgalls
nutgrass943933nutgras_s
nutgrasses1143433nutgrasses
nuthouses1246343nuthouses
oatcakes1445543oatcakes
outages82317323out_ages
outasks1138173out_asks
outbakes1439993outbakes
outcalls1038743outcalls
outcaper1246873outcaper
outcapers1344383outcapers
outcast91013743outcas_t
outcaste10119613outcaste
outclass1037203outclas_s
outclasses12145133outclasses
outcomes1239763outcomes
outcries10313573outcries
outcurses1145803outcurses
outdares92712463outdares
outdates93114743outdates
outfaces132311393outfaces
outfasts11117233outfasts
outgasses1036663outgasses
outgazes18248713outgazes
outlasts8108713outlasts
outpaces122411943outpaces
outpass939713outpas_s
outpasses1146613outpasses
outraces102217863outraces
outrages92215933outrages
outraises9311023outraises
outrates82421373outrates
outraves112313833outraves
outtakes12310033outtakes
outtasks1235633outtasks
outwashes15116183outwashes
outwastes12127693outwastes
pectases122411193pectases
purchases1645633purchases
stases64225563_st_ases
subbases1239063subbases
subcastes1387493subcastes
subcauses1346213subcauses
sucrases10310253sucrases
suitcase1043893suitcase_
surbases10310003surbases
surceases1157473surceases
teases65426273__teases
ukases10358063_u_kases
uncages103213773_uncages
uncakes133012743_uncakes
uncase83817433_uncase_
uncased104216953_uncased
uneases73316263_uneases
upases84112903_u_pases
upcasts11185643_upcasts
urases63723563_u_rases
ureases74416723_ureases

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621166.22023498.7
3Display Results1161160.0462521.7
 (SQL Overall)1786911166.67226782.2
 
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.