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

131 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
noose5562406(None) 
goose65925901goose
loose56627681loose
moose76327191moose
nodose738881nodose
noise55723731noise
noosed75018011noosed
nooser65517821nooser
nooses65623641nooses
nose46739361n_ose
roose56127091roose
arose55832082arose
boos67955032boos_
boost75132472boost
booze164718912booze
bouse75931852bouse
bowse105420632bowse
brose75227032brose
choose115116142choose
chose105925402chose
close76425222close
comose105016842comose
cooee74531022cooee
coos67456492coos_
copse95623922copse
corse75036182corse
dose56442432_dose
douse66329722douse
dowse96020812dowse
erose55727272erose
fosse86119462fosse
goos57644912goos_
goosed86817032goosed
gooses75723052gooses
goosey105913512goosey
goosy96018882goosy
gorse65926812gorse
hoise85224772hoise
horse86132652horse
hose76547242_hose
house89131422house
jocose1537102jocose
looie55624242looie
loos49051122loos_
loosed75520892loosed
loosen66615962loosen
looser65219942looser
looses67328242looses
lose45144582_lose
louse56131012louse
lowse87219902lowse
moos66051302moos_
morose85116242morose
morse76032702morse
mouse77133002mouse
naos47429732naos_
noble74420992noble
nobs66436902nobs_
node513036882n_ode
nodes64633492nodes
nods55838222nods_
noes45845392noes_
nogs56534612nogs_
noised75416232noised
noises65021852noises
noisy86813362noisy
nolos54423352nolos_
nome66038422n_ome
nomes74933122nomes
nomos75919742nomos_
noms65636402noms_
nonce75719822nonce
none45743172n_one
nones55639132nones
nonuse63212252nonuse
noo37154042noo__
noodge8337572noodge
noodle73212542noodle
noogie73612312noogie
nook85728492noo_k
nookie103712432nookie
nooks95420392nooks
nooky124814812nooky
noon47134622noo_n
noons54125282noons
noosers74913922noosers
nope65934192n_ope
nos38859322n_os_
nosed65524552n_osed
noses55435642n_oses
nosey85619882n_osey
nosh76223542n_osh
nosy76322892n_osy
note46239962n_ote
notes55034582notes
nous46136982nous_
nouses64627162nouses
novae85913122novae
nowise9511072nowise
nows75738232nows_
nurse54420122nurse
onos46229002onos_
ooze136420602_ooze
ose38147342__ose
owse76321622_owse
poise75127892poise
poos65949112poos_
poove104514302poove
porose84818742porose
pose66441732_pose
posse74722272posse
prose75835122prose
roosed75621592roosed
rooser63921882rooser
rooses65526232rooses
roost55730932roost
rose46148902_rose
rouse56634702rouse
snooze15439992snooze
souse56530772souse
those85218142those
torose64317692torose
torse55833332torse
touse55430672touse
unloose797862unloose
whose114914532whose
woos76238802woos_
woosh113710732woosh
worse86525262worse
youse85322232youse
zoos135828802zoos_

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001311.64032804.9
3Display Results1311310.0304366.7
 (SQL Overall)1786911311.763101356.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.