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

253 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
luces7552843(None) 
duces86327471duces
laces76141761laces
lubes74727991lubes
luce65132571luce_
lucks115723561lucks
lucres84513301lucres
ludes65728851ludes
lues45943551lu_es
luges65928751luges
lunes55337771lunes
lures56138531lures
lutes55836661lutes
luxes124921501luxes
puces94924631puces
aces67645092_aces
almuces11316822almuces
aures55137092aures
bices95029962bices
blues75127042blu_es
blumes105917792blumes
bucks134824292bucks
buses75936012buses
butes714535872butes
clucks144512072clucks
clues74623032clu_es
cruces105117542cruces
cubes95028162cubes
cues65438982cu_es
cukes115422092cukes
cures75645432cures
cutes79438322cutes
daces85030682daces
deuces94015512deuces
dices86434242dices
duce76933502duce_
ducks124823212ducks
ducts85319892ducts
dudes75424372dudes
dues56045502du_es
dukes105023472dukes
dunces95215752dunces
dunes65332172dunes
dupes86425932dupes
dures65635922dures
educes94011952educes
eludes75417682eludes
elutes64020312elutes
faces106439432faces
fauces114916152fauces
feces105625362feces
fices106031162fices
flues84626922flu_es
flukes135114192flukes
flumes115119732flumes
flutes95421782flutes
fluxes165212932fluxes
fucks144419252fucks
fucus105515892fucus
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
fyces139813642fyces
glaces94218032glaces
glues65125682glu_es
glumes94516812glumes
glutes74517672glutes
gucks123917302gucks
gudes74520812gudes
gules64831042gules
hucks144322172hucks
hues75235232hu_es
ices66129642_ices
jubes145420742jubes
jucos144111712jucos
juices1549422juices
jukes165319102jukes
jupes145218552jupes
jutes125125132jutes
kluges11389572kluges
kues86426772ku_es
lace66848472lace_
laced87132642laced
lacer75833752lacer
lacers85225252lacers
lacey105820912lacey
laches116528352laches
lacks116129202lacks
lacs66942482lac_s
lades65141272lades
lakes95737652lakes
lames75445542lames
lances84824102lances
lanes54946792lanes
lares54852632lares
lases54944762lases
launces9329002launces
laves86039152laves
laxes125430092laxes
lazes145129572lazes
leches115421312leches
lees45455882l_ees
leges64427292leges
lenes54738522lenes
les35663072l__es
leses54930812leses
leudes75314092leudes
lexes127225262lexes
lice66045062lice_
liches114724292liches
licks115325392licks
lies46454192l_ies
likes96231902likes
limes75636502limes
lines57054572lines
lives86133192lives
lobes75331002lobes
lochs106715512lochs
locks115126922locks
locoes85516582locoes
locos75822602locos
locus74819992locus
lodes66436912lodes
loges66534202loges
lopes76437342lopes
lores55045402lores
loses56742012loses
louies64525102louies
loupes84918052loupes
louses66230282louses
loves85332012loves
lowes85732462lowes
loxes125227472loxes
luaus54514902luaus
lube64731562lube_
lubed85319892lubed
lucent8313822lucent
lucern846102lucern
lucerns935752lucerns
lucid84314572lucid
lucites9311862lucites
luck105329822luc_k
lucked135118022lucked
luckies133313682luckies
lucky145515012lucky
lucre76415522lucre
lude55331642lude_
luffs114516282luffs
luge55531642luge_
luged74019092luged
luger65322082luger
lugers74617022lugers
lugs55233522lu_gs
lulls54119652lulls
lulus54315162lulus
lumas75622912lumas
lumen75220902lumen
lumens85013972lumens
lumps95624982lumps
lums65734242lu_ms
lunas55025012lunas
lunches124115442lunches
lune47140492lune_
lunet56835422lunet
lunets66914762lunets
lunges76123422lunges
lungs65223882lungs
lunies64723012lunies
lunks94822452lunks
lunts55826902lunts
lupus74512522lupus
lurches123311662lurches
lure45142462lure_
lured65427492lured
lurer54625312lurer
lurers64217492lurers
lurex124816732lurex
lurks95218742lurks
lushes94022742lushes
lusts55022802lusts
lusus54813872lusus
lute46341012lute_
lutea54819072lutea
luted64826142luted
lutzes153711922lutzes
luvs75818502lu_vs
luxe115222692luxe_
lycea10418942lycea
lycee104716742lycee
lycees11428862lycees
lyches144213612lyches
lyes75530832l_yes
lyres85019962lyres
lyses84518252lyses
maces97139962maces
muches134718992muches
mucks134622642mucks
mucus94015742mucus
mules75034292mules
mures75937222mures
muses75134302muses
mutes75033782mutes
nudes64723292nudes
nukes95418122nukes
ouches114322182ouches
ounces83617772ounces
paces96741112paces
places104323702places
plucks14379732plucks
plumes104318132plumes
pluses83618072pluses
pubes94423402pubes
puce85127882puce_
pucks134322102pucks
pukes114523022pukes
pules74538812pules
puses75532202puses
races74943242races
rices75536152rices
rubes74928412rubes
ruches114819582ruches
rucks114422052rucks
rues46044482ru_es
rules55234252rules
runes55530222runes
ruses56136582ruses
sauces84919502sauces
sices75637272sices
slices84022852slices
slues54527172slu_es
sluices959072sluices
sucks114523072sucks
sucres84218892sucres
sues46247652su_es
supes75628302supes
syces106416462syces
taces76237802taces
truces84916332truces
tubes74826452tubes
tucks114721122tucks
tules54532792tules
tunes55332192tunes
tuxes124316042tuxes
ukes86122812_ukes
ulcer7310752ulcer
ulcers839382ulcers
uses44931112_uses
utes45930882_utes
vices105725532vices
voces105918052voces
yucas106013912yucas
yucks144717192yucks
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.440406115.9
2DLD Change Limit538002531.65332546.9
3Display Results2532530.0634015.9
 (SQL Overall)1786912532.15682880.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.