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

245 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
lezzies153620(None) 
lezzes14387831lezz_es
lezzie1435331lezzie_
dizzies16279752dizzies
fezzes174910402fezz_es
lazies154418782l_azies
lefties10312072lefties
levies93919862le_vies
tizzies15287892tizzies
aeries64737783ae_ries
beanies93821093beanies
beedies10314203beedies
belies84631053be_lies
bellies94023723bellies
bennies93917313bennies
benzines1938213benzines
benzins1838693benzins
berries94423553berries
bevies114017303be_vies
bezazzes1741983bezazzes
bezils1711310603be_zils
bizzes163910843bizz_es
blennies1056933blennies
buzzes165011173buzz_es
clergies1137903clergies
cozies174521413_cozies
cozzes164510893cozz_es
crazies183413853crazies
dazzles1636413dazzles
dearies83526273dearies
decries103319803decries
defies104624053de_fies
deifies113317453deifies
deities82621923deities
dellies83622213dellies
demies94825803de_mies
denies74729643de_nies
derbies103016053derbies
derries83124623derries
dexies145018343de_xies
dizzied17236133dizzied
dizzier16317543dizzier
dizziest17266723dizziest
doozies173812723doozies
easies64126633_easies
eddies83313163_eddies
elegies81312903elegies
elegizes18137103elegizes
envies9314053_envies
espies83716803_espies
eyries93816813_eyries
feazes184514173feaz_es
feezes184412613feez_es
fellies104119743fellies
ferlies103216693ferlies
ferries103521083ferries
fezes175220023fe_z_es
fezzed18398243fezz_ed
fizzes174512553fizz_es
fizzier18326713fizzier
fizziest19226073fizziest
fizzles18339063fizzles
floozies20326953floozies
frenzies2037713frenzies
frizzies19315933frizzies
fuzzes175412253fuzz_es
fuzzier18256523fuzzier
fuzziest19235793fuzziest
genies75324943ge_nies
ghazies2036913ghazies
guzzles16328043guzzles
heavies132713873heavies
heezes184211643heez_es
heinies102514543heinies
henries102718283henries
herries104025073herries
jazzes21347883jazz_es
jazzier2233883jazzier
jazziest2333813jazziest
jellies143816533jellies
jemmies18318333jemmies
jennies143511623jennies
jerkies183411583jerkies
jerries143817513jerries
jetties143613123jetties
jezails2334163jezails
kebbies1537253kebbies
kellies113516853kellies
kelpies13289903kelpies
kerries113317913kerries
kewpies16246923kewpies
laddies93715053laddies
ladies75124883l_adies
laities7320343laities
lambies113015113lambies
lassies74420103lassies
lazes145129573l_az_es
lazied164610653l_azied
lazier154214613l_azier
laziest163814483l_aziest
leaches123319343leaches
leadier83212723leadier
leadiest93314993leadiest
leafier10329833leafier
leafiest113410893leafiest
leagues837943leagues
leakier114010993leakier
leakiest123212803leakiest
lealties8310793lealties
learier73415663learier
leariest83117853leariest
leases65428113le_ases
leashes103514403leashes
leaves94222383le_aves
leavier10319993leavier
leaviest112910823leaviest
leches115421313le_ches
lechwes1535063lechwes
lectins92515003lectins
ledges84918013le_dges
ledgier9458503ledgier
ledgiest10288593ledgiest
leeches123911933leeches
leerier73111503leerier
leeriest83112883leeriest
lees45455883le___es
legacies1139043legacies
legates82917683legates
leges64427293le__ges
leggier9368233leggier
leggiest10308233leggiest
leggins9259473leggins
legits71313003le_gits
legumes1036633legumes
leis45739603le__i_s
lemures938793lemures
lenes54738523le__nes
lenis56326863le_ni_s
lenites7818443lenites
lenities8315943lenities
lenses64620893le_nses
lentils73912973lentils
leones64417723le_ones
leptins92412693leptins
leses54930813le__ses
lessees73510243lessees
letches124015483letches
lethes94818083le_thes
leucines1037273leucines
leucins938103leucins
leucites1037333leucites
leudes75314093le_udes
levees93714523le_vees
levied104111433le_vied
levier94013873le_vier
leviers103510343le_viers
levins94514653le_vins
levis85818553le_vi_s
levities11310713levities
lewis85315843le_wi_s
lewises1039133lewises
lexemes1635673lexemes
lexes127225263le__xes
lexis125916033le_xi_s
lezzy16608083lezz__y
lies46454193l___ies
lilies63021413l_ilies
lindies8416583lindies
lobbies113612463lobbies
lollies73116923lollies
longies82916553longies
loobies93814103loobies
looies65025833l_ooies
loonies73919543loonies
lories64933043l_ories
lorries74518353lorries
louies64525103l_ouies
luckies133313683luckies
luggies93011213luggies
lunies64723013l_unies
lutzes153711923lutz_es
mealies92821933mealies
meanies93620743meanies
meinies92516073meinies
mercies113817563mercies
mezes167719263me_z_es
mezzos1635053mezz_os
mizzles17329493mizzles
muezzins1842663muezzins
muzzier17326553muzzier
muzziest18175833muzziest
muzzles17299683muzzles
neddies92710703neddies
nellies73418723nellies
newbies12147423newbies
newies91014073ne_wies
newsies101310383newsies
nozzles15276303nozzles
nuzzles15298123nuzzles
peavies122213403peavies
peeries93623023peeries
pennies94218813pennies
peonies93620153peonies
perries93226603perries
pizzles17329273pizzles
plenties10314693plenties
puzzles17318973puzzles
razzes144910073razz_es
readies83324713readies
redries83721713redries
reflies104418533reflies
refries104419733refries
reifies104218283reifies
relies65036423re_lies
replies94521043replies
resizes164216843resizes
reties65436193re_ties
retries74129073retries
rezones163213943rezones
seizes154317533seiz_es
seizins164010133seizins
selkies113513353selkies
series64540973se_ries
serries73925353serries
sizzles15349633sizzles
sleazes162810333sleaz_es
sleazier1735123sleazier
sleaziest1836063sleaziest
teazles16308923teazles
techies12513603techies
teddies92711283teddies
tekkies1035943tekkies
tellies73820503tellies
tennies73017973tennies
terries73425633terries
veeries102916893veeries
veggies1237553veggies
vegies104314273ve_gies
wearies103020223wearies
wedgies123910213wedgies
weenies102915093weenies
weepies122811743weepies
wellies103719073wellies
wizzes175110773wizz_es
zizzles14307093zizzles

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272455.70323501.1
3Display Results2452450.0932634.4
 (SQL Overall)1786912456.20228811.8
 
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.