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

239 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
puces9492463(None) 
duces86327471duces
luces75528431luces
paces96741111paces
pubes94423401pubes
puce85127881puce_
pucks134322101pucks
pukes114523021pukes
pules74538811pules
puses75532201puses
aces67645092_aces
apices104916262apices
aures55137092aures
bices95029962bices
bucks134824292bucks
buses75936012buses
butes714535872butes
cruces105117542cruces
cubes95028162cubes
cues65438982cu_es
cukes115422092cukes
cures75645432cures
cutes79438322cutes
daces85030682daces
deuces94015512deuces
dices86434242dices
duce76933502duce_
ducks124823212ducks
ducts85319892ducts
dudes75424372dudes
dues56045502du_es
dukes105023472dukes
dunces95215752dunces
dunes65332172dunes
dupes86425932dupes
dures65635922dures
educes94011952educes
faces106439432faces
fauces114916152fauces
feces105625362feces
fices106031162fices
fucks144419252fucks
fucus105515892fucus
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
fyces139813642fyces
gucks123917302gucks
gudes74520812gudes
gules64831042gules
hucks144322172hucks
hues75235232hu_es
ices66129642_ices
jubes145420742jubes
jucos144111712jucos
juices1549422juices
jukes165319102jukes
jupes145218552jupes
jutes125125132jutes
kues86426772ku_es
laces76141762laces
lubes74727992lubes
luce65132572luce_
lucks115723562lucks
lucres84513302lucres
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lunes55337772lunes
lures56138532lures
lutes55836662lutes
luxes124921502luxes
maces97139962maces
muches134718992muches
mucks134622642mucks
mucus94015742mucus
mules75034292mules
mures75937222mures
muses75134302muses
mutes75033782mutes
nudes64723292nudes
nukes95418122nukes
opuses84012242opuses
ouches114322182ouches
ounces83617772ounces
pacas96029402pacas
pace86345772pace_
paced106931682paced
pacer96131612pacer
pacers105124542pacers
pacey126720282pacey
packs135528932packs
pacs85842182pac_s
pacts95125802pacts
pages85235072pages
pales75753802pales
panes76148692panes
pares77164482pares
pases75346502pases
pates76047892pates
pauses84621472pauses
paves104833922paves
paxes144928422paxes
peaces106324082peaces
pechs125516202pechs
pecks135724432pecks
pecs84634102pec_s
pedes85327292pedes
pees65257372p_ees
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
pes57259782p__es
picas94626522picas
pice84641092pice_
picks135226142picks
pics85633912pic_s
pieces104217272pieces
pies66949602p_ies
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pixes144323172pixes
places104323702places
plies74526512plies
plucks14379732plucks
plumes104318132plumes
pluses83618072pluses
pocks135022962pocks
pokes116133012pokes
poles75351002poles
pomes94833932pomes
ponces104720842ponces
pones74547042pones
popes95933812popes
pores75849032pores
poses74642762poses
pouches144116742pouches
pounces114113892pounces
poxes145325722poxes
prees75937172prees
prices104524542prices
pries74339532pries
prudes94215442prudes
prunes83419062prunes
pubis94616472pubis
pubs85029212pu_bs
puck124927942puc_k
pucka133412802pucka
pucker143817632pucker
puckers153514672puckers
puds75630512pu_ds
puffs134114932puffs
pugs76332772pu_gs
pujas145513322pujas
puke105025462puke_
puked124716222puked
pule65040952pule_
puled84926522puled
puler74826622puler
pulers83820282pulers
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pu_ls
pulse74219972pulse
pulses83818662pulses
pumas95121562pumas
pumices1338272pumices
pumps115520602pumps
punas74826752punas
punches144816132punches
pungs85422222pungs
punks114822682punks
puns66641482pu_ns
punts75828002punts
pupas95219282pupas
pups86032232pu_ps
pupus94614042pupus
pure65543332pure_
puree74632842puree
purees84721682purees
purer75127902purer
purest84021932purest
purges94421762purges
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pu_rs
purse76028892purse
purses84826372purses
pus55547842pu__s
pushes114621662pushes
puss64830132pu_ss
pusses84322842pusses
puts65641752pu_ts
putts75719272putts
putzes174212522putzes
pyes95528992p_yes
pyres105523882pyres
pyxes175911402pyxes
races74943242races
rices75536152rices
rubes74928412rubes
ruches114819582ruches
rucks114422052rucks
rues46044482ru_es
rules55234252rules
runes55530222runes
ruses56136582ruses
sauces84919502sauces
sices75637272sices
spaces104722632spaces
spices104326032spices
spruces113810502spruces
spues75025382spu_es
spumes1021314882spumes
sucks114523072sucks
sucres84218892sucres
sues46247652su_es
supes75628302supes
syces106416462syces
taces76237802taces
truces84916332truces
tubes74826452tubes
tucks114721122tucks
tules54532792tules
tunes55332192tunes
tuxes124316042tuxes
ukes86122812_ukes
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.360496363.9
2DLD Change Limit538002391.75030742.9
3Display Results2392390.0763144.7
 (SQL Overall)1786912392.18681743.4
 
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.