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

122 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
nutcase97576(None) 
nutcases1085791nutcases
mutase82811992mut_ase
notecase1044822notecase
nutate63017372nut_ate
outcast91013742outcast
outcaste10119612outcaste
suitcase1043892suitcase
uncase83817432_uncase
anatase738943anat_ase
autocade1146683autocade
butane8313653but_ane
butches144315363butches
carcase11312743carcase
case65848083___case
cupcake1743953cupcake
cutches143216463cutches
cutlas8313103cutlas_
cutlases1038033cutlases
cutlass938013cutlass
cuttage10318343cuttage
discase102912863discase
encase83714363_encase
euclase938933euclase
fucose11167683fu_cose
furcate12310453furcate
guanase836213guanase
guttae73210583gutta_e
guttate8328903guttate
hotcake1644543hotcake
hutches153613523hutches
incase83615283_incase
inulase739413inu_lase
lactase937963lactase
mucose10149313mu_cose
muscae10410673musca_e
mutases92012043mut_ases
mutate83017483mut_ate
mutches143314283mutches
narcose95910393narcose
nautches1336083nautches
nictate9310223nictate
nitchie1247233nitchie
nitrate72017013nitrate
noncash1245163noncash
notate63217863not_ate
notches123513653notches
notecases1145173notecases
nubias8310093nubias_
nuchae11218513nu_chae
nuclease1046213nuclease
nuncle839363nunc_le
nuncles939843nuncles
nurse54420123nu__rse
nutant6316383nut_ant
nutated83113423nut_ated
nutates73214973nut_ates
nutgall844443nutgall
nutgrass943933nutgrass
nuthouse1145833nuthouse
nutlike113110113nutlike
nutrias739813nutrias_
nuts45032673nut__s_
nutsy85711503nut__sy
oatcake1345363oatcake
outage72017533out_age
outask1039103out_ask
outate62923403out_ate
outbake13310773outbake
outcall9310123outcall
outcaper1246873outcaper
outcastes11118913outcastes
outcasts10108683outcasts
outclass1037203outclass
outcome11310573outcome
outcurse1045833outcurse
outdare83113403outdare
outdate83016423outdate
outface123011973outface
outfast101412123outfast
outgas7313203outgas_
outgave11259563outgave
outgaze17239223outgaze
outlast71015443outlast
outpace112613023outpace
outpass939713outpass
outrace92418553outrace
outrage82616893outrage
outraise8311933outraise
outrate72323183outrate
outrave102614413outrave
outtake11310793outtake
outtask1137053outtask
outwash13187613outwash
outwaste11147943outwaste
pectase112410363pectase
purchase1545293purchase
subbase1139323subbase
subcaste1287853subcaste
subcause1265823subcause
sucrase9310343sucrase
suitcases1144453suitcases
sulcate9314423sulcate
surbase939793surbase
surcease1086883surcease
sutras64818593sutras_
suttas63813793suttas_
tease55428713__tease
ukase9428493_u_kase
uncage93014873_uncage
uncake122813523_uncake
uncased104216953_uncased
uncases93516553_uncases
uncast84215713_uncast
unease63816643_unease
untame82513603unt_ame
upcast102710093_upcast
urase54624693_u_rase
urease64516993_urease
utas45924953_ut_as_
yucas106013913yu_cas_
yuccas13426553yuccas_

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.406440125.6
2DLD Change Limit1340271226.64020184.8
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.09225196.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.