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

240 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
duces8632747(None) 
daces85030681daces
deuces94015511deuces
dices86434241dices
duce76933501duce_
ducks124823211ducks
ducts85319891ducts
dudes75424371dudes
dues56045501du_es
dukes105023471dukes
dunces95215751dunces
dunes65332171dunes
dupes86425931dupes
dures65635921dures
educes94011951educes
luces75528431luces
puces94924631puces
abduces1286242abduces
aces67645092_aces
adduces1185762adduces
aures55137092aures
bices95029962bices
bucks134824292bucks
buses75936012buses
butes714535872butes
cruces105117542cruces
cubes95028162cubes
cues65438982cu_es
cukes115422092cukes
cures75645432cures
cutes79438312cutes
dace76934922dace_
dales66439742dales
dames85435852dames
dances95120652dances
dares66146702dares
dates65639152dates
daubes94913702daubes
dazes155024142dazes
decks124822192decks
decos85522122decos
deduces1168792deduces
dees56356632d_ees
deices94119372deices
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
deuce84517492deuce_
deuced104112122deuced
dexes135224512dexes
dice75841892dice_
diced95824682diced
dicer85426422dicer
dicers94720742dicers
dicey114819332dicey
dicks125824692dicks
dies55653522d_ies
dikes105831332dikes
dimes85833042dimes
dines66449152dines
dites66339152dites
dives95832402dives
docks126022312docks
docs75631152doc_s
does56554472d_oes
doges75630162doges
doles67843752doles
domes85735562domes
dopes84935042dopes
doses65938502doses
dotes65836692dotes
douce85518422douce_
douches134315232douches
douses74928932douses
doves94728152doves
dozes155226302dozes
drees65628522drees
dries64733672dries
drupes94912652drupes
druses75517252druses
duads76515342duads
duals65620082duals
dubs78432192du_bs
ducal84816422ducal
ducat86225902ducat
ducats95011762ducats
duchess1335552duchess
duchies133312312duchies
duchy144310872duchy
duci76422622duc_i
duck115929172duc_k
ducked144718012ducked
ducker134317992ducker
duckers143214712duckers
duckies143613812duckies
ducky154216112ducky
duct75735462duc_t
ducted104012122ducted
dude65629662dude_
duded84417132duded
duds65530142du_ds
due45249862du_e_
duel56729702du_el
duels65619232duels
duet56446262du_et
duets65323882duets
duffs125216622duffs
dufus94010812dufus
dugs614832282du_gs
duits65021882duits
duke95628102duke_
duked115218462duked
dulcet9314492dulcet
dulcets1046282dulcets
dulls64523742dulls
dulse65415042dulse
dulses73913652dulses
dumas85420432dumas
dumbs105915752dumbs
dumps105220102dumps
dunce86319262dunce_
dunches133312582dunches
dune56137582dune_
dungs75821972dungs
dunks105621192dunks
duns55140432du_ns
dunts65828412dunts
duos56728132du_os
dupe76630602dupe_
duped95118322duped
duper85519002duper
dupers94615602dupers
dups75929512du_ps
duras65727722duras
dure56341812dure_
dured75025402dured
duress74712062duress
durns64819862durns
duros65422692duros
durrs65519992durrs
dusks105317252dusks
dusts65923562dusts
duties74921902duties
duvet9321872duvet
duvets1039222duvets
dyes85331892d_yes
dykes135215572dykes
dynes95917582dynes
educe84313452educe_
educed10418852educed
educts9439892educts
faces106439432faces
fauces114916152fauces
feces105625362feces
fices106031162fices
fucks144419252fucks
fucus105515892fucus
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
fyces139813642fyces
gucks123917302gucks
gudes74520812gudes
gules64831042gules
hucks144322172hucks
hues75235232hu_es
ices66129642_ices
induces103611812induces
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
mures75937212mures
muses75134302muses
mutes75033782mutes
nudes64723292nudes
nukes95418122nukes
ouches114322182ouches
ounces83617772ounces
paces96741112paces
pubes94423402pubes
puce85127882puce_
pucks134322102pucks
pukes114523022pukes
pules74538812pules
puses75532202puses
races74943242races
reduces10513342reduces
rices75536152rices
rubes74928412rubes
ruches114819582ruches
rucks114422052rucks
rues46044482ru_es
rules55234252rules
runes55530222runes
ruses56136582ruses
sauces84919502sauces
seduces1069282seduces
sices75637272sices
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 5 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.186960704.3
2DLD Change Limit538002403.81314109.6
3Display Results2402400.1231951.2
 (SQL Overall)1786912404.12243350.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.