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

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
muley10481928(None) 
mule65236971mule_
muled85824431muled
mules75034291mules
muleys11409641muleys
mulley114013451mulley
agley96917332agley
alley85721672alley
amulet8419572amulet
bluey104817052bluey
bulgy115214102bulgy
bulky146215572bulky
bully105124812bully
burley114715752burley
culet76040342culet
culex144613932culex
cully105520462cully
cutey105819792cutey
dully94921632dully
duly85323032dul_y
fley106626852_fley
foley115222302foley
fully114820862fully
gley85724652_gley
gluey95715262gluey
gules64831042gules
gulfy124612002gulfy
gulley104213162gulley
gully94020682gully
gulpy114612762gulpy
holey115626902holey
hulky155312472hulky
hurley125012522hurley
julep14310532julep
ley66246812__ley
male66052302male_
males75049792males
malmy124816342malmy
malty106721702malty
mamey125418832mamey
matey107022662matey
mauled94817822mauled
mauler84416712mauler
medley1298332medley
melee73729102melee
melty104918362melty
mile66352572mile_
miler75733062miler
miles74645072miles
milky144014442milky
milty104720072milty
moldy115014652moldy
mole66251832mole_
moles74747922moles
molly105222492molly
moly96031912mol_y
money104826842money
mooley11311632mooley
mopey124821822mopey
mosey105922872mosey
motey105922952motey
motley1139382motley
mouldy12437412mouldy
mousey115216192mousey
mucky165015252mucky
muddy123812232muddy
muggy125612372muggy
muhly1358522muhly
mulch124012972mulch
mulct93820082mulct
muleta839232muleta
mull65128802mul_l
mulla74317112mulla
mulled94721552mulled
mullen83714762mullen
muller83820352muller
mullet84126822mullet
mulleys12299202mulleys
mulls75124152mulls
mummy114913622mummy
mure65941332mure_
mured85726702mured
mures75937212mures
murex145517172murex
murky145216682murky
murrey114312262murrey
murry105120232murry
muse67136032muse_
mused85524582mused
muser76024122muser
muses75134302muses
mushy135316632mushy
musky144715292musky
mussy104117642mussy
musty105620952musty
mute65136872mute_
muted85023382muted
mutely113811652mutely
muter74525542muter
mutes75033782mutes
muzzy188410602muzzy
pule65040952pule_
puled84926522puled
puler74826622puler
pules74538812pules
pulley113713402pulley
pulpy124612362pulpy
pusley11379612pusley
quey164616472qu_ey
riley84420582riley
rule49938422rule_
ruled65822522ruled
ruler54923342ruler
rules55234252rules
ruly76323142rul_y
smiley114012302smiley
sulky124715362sulky
sully84622902sully
tule45735872tule_
tules54532792tules
yule75725142yule_
yules84521582yules

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 Filter178691538000.0931921408.6
2DLD Change Limit538001222.04626295.2
3Display Results1221220.0304066.7
 (SQL Overall)1786911222.16982384.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.