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

347 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
cred7653088(None) 
acred87126351acred
bred75130971bred
cared86050091cared
cered85227441cered
coed77140541coed
cored85044221cored
credo84815561credo
creds85418771creds
creed85727391creed
crew96122671crew
cried84624281cried
crud75219611crud
cued76329561cued
cured85932131cured
ired55131871ired
red46755801_red
abed79734132abed
aced79540882aced
ached119227832ached
acned87520662acned
acre67330772acre_
acres76327762acres
acrid86920102acrid
acted88521732acted
aged67334252aged
ahed89536252ahed
aired66032922aired
aped78538152aped
arced88224162arced
are37874572are_
area45843392area
ares45871022ares
arid57642712arid
armed86324432armed
awed88436032awed
axed128829612axed
bared85144482bared
bed67950622_bed
bled75729312bled
bored85034302bored
brad75234342brad
bread85523112bread
brede85520502brede
bree67241262bree
breed85526692breed
bren65629562bren
brew95023562brew
cad67456362c_ad
cade76443912cade
caged95426362caged
caid77837532caid
caked126128622caked
caned85838092caned
caped104931802caped
card710245872card
carded105424902carded
care66968372care_
carer74942332carer
cares77369182cares
caret75360562caret
carex144822292carex
caried94528692caried
carked134024822carked
carped115923762carped
carted98631442carted
carved124320852carved
cased86032412cased
caved116227562caved
cawed116627062cawed
cede74928762c_ede
ceded96118552ceded
cedi74919272c_edi
cee55952702c_ee
cees65941592cees
cel56040552c_el
cep75736332c_ep
cere66741472cere
ceres75540012ceres
cero66329452cero
chad105525502chad
chared125423692chared
chef125125622chef
chew126622132chew
chez184519022chez
chid106626402chid
chored125321882chored
cire65836372cire_
cires74932912cires
cited84421952cited
clad76225822clad
clef97028182clef
clew95520572clew
clod76124612clod
clued84917682clued
cod69660122c_od
code77347732code
coded95433182coded
coeds85920162coeds
coked124730692coked
cold77338772cold
coled85540752coled
coned86040052coned
cooed84534342cooed
coped105036842coped
cord76740922cord
corded105923352corded
core67263112core_
corer75538872corer
cores76361852cores
corked135020782corked
corned95224522corned
coted85033852coted
coved115027372coved
cowed115637842cowed
coxed154322812coxed
coyed114623802coyed
crab85727672crab
crag75625302crag
cram85635492cram
craned96121652craned
crap85731842crap
craped116120522craped
crated94827772crated
craved125417772craved
craw97725262craw
crazed184714452crazed
creak115418432creak
cream95721342cream
credal9311672credal
credit9315192credit
credos94612842credos
creeds94714772creeds
creek114917392creek
creel75121482creel
creep95218102creep
creme94319322creme
crepe95520722crepe
creped114115702creped
crept95125892crept
crepy124812702crepy
cress75022832cress
crest74632692crest
crewed125316552crewed
crews105917492crews
crib86323582crib
crier74724462crier
cries75438402cries
cris66233432cris
crit65743712crit
croc85723732croc
crop87628632crop
crow96428132crow
crowd115815622crowd
crowed124717292crowed
cru57129562cr_u
crude86018572crude
cruds85815852cruds
cruel74815902cruel
cruet74831842cruet
crus65828482crus
crux135415002crux
cry89726242cr_y
cubed105519702cubed
cud67937452c_ud
cue57544182cue_
cues65438982cues
curbed114615872curbed
curd77634982curd
curded104217162curded
cure66149122cure_
curer75030752curer
cures75645432cures
curet75447642curet
curled95021652curled
curred94319262curred
cursed94321252cursed
curved124815222curved
dared75935012dared
deed65340902deed
died66137852died
dread74419022dread
dree56638322dree
dreed75222842dreed
dreg66821652dreg
drek96321082drek
drew86221672drew
dried75321382dried
dured75025402dured
dyed96720762dyed
eared65139502eared
eched116919222eched
ed38645182__ed
eked96718022eked
ere36352772ere_
erred65915672erred
exed125420592exed
eyed86623232eyed
fared95842342fared
fed76548352_fed
feed84538902feed
fired94829742fired
fled85429772fled
free75940182free
freed95223542freed
fremd115010322fremd
fret75845042fret
fried95322912fried
gaed66031512gaed
ged57044532_ged
geed65435502geed
gied64631982gied
gled65631142gled
gored75227082gored
grad66829862grad
gree56641562gree
greed75125692greed
grew85620262grew
grey85624042grey
grid65829612grid
gyred105114092gyred
haed86338582haed
hared95742182hared
heed86437602heed
herd84933062herd
hied85434042hied
hired95226262hired
hoed87837982hoed
hued86925852hued
iced78721892iced
ire36943172ire_
ires45639282ires
irid55927172irid
irked104510922irked
jeed125428502jeed
led46254552_led
lied55838092lied
lured65427492lured
med66146742_med
meed74934702meed
mired85729222mired
mured85726702mured
nacred95212492nacred
need54934152need
nerd56624942nerd
oared65030652oared
ochred12328002ochred
ocrea73311822ocrea
ohed87825182ohed
oped76230152oped
orad56031692orad
orbed85516192orbed
ore36661832ore_
oread64619602oread
ores46056682ores
owed86833872owed
pared86946762pared
ped66751522_ped
peed76239182peed
pied75035362pied
pled75231432pled
pored85234512pored
pree67044732pree
preed85128112preed
prep86427672prep
prex135722972prex
prey96228482prey
prez156126312prez
pried84426862pried
prod76129502prod
rad47662002_rad
rared65738322rared
re26153742_re_
read55942532_read
reb55844962_reb
rec55645462_rec
redd66323172_redd
rede55037662_rede
redo56029362_redo
reds56042862_reds
ree37974072_ree
reed55549622reed
ref66053292_ref
reg46146492_reg
rei35647252_rei
rem56150042_rem
rend56136572_rend
rep55847802_rep
res35565042_res
ret35982832_ret
rev65336622_rev
rex105740992_rex
rid46754622_rid
rod47953892_rod
rued55729792rued
sacred94917102sacred
scared95227292scared
scored94621132scored
scree720031702scree
screed95718922screed
screw109318532screw
scried95817302scried
scrod85115062scrod
seed55549482seed
sered65737292sered
shed86536152shed
shred98125612shred
sired66134282sired
sled55334372sled
sned56026052sned
sored66141782sored
sped76031492sped
sued56537932sued
tared69340052tared
ted46446562_ted
teed55439262teed
tied55535212tied
tired65228902tired
toed56137042toed
trad55630912trad
tread64821702tread
tree47745812tree
treed65626732treed
tref77030992tref
trek86222312trek
trend64817452trend
tres46542902tres
tret46653532tret
trey77228792trey
tried65026912tried
trod57627952trod
trued65117692trued
tyred95816432tyred
urd46427042ur_d
urea46528052urea
uredo65112992uredo
urged75316032urged
urped84615282urped
used55722822used
vied86328632vied
wared96339872wared
wed75843622_wed
weed85637512weed
wired95327642wired
wren78221682wren
wried95518562wried
zed135431172_zed

Search took 2 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 Filter178691298720.1231452772.4
2DLD Change Limit298723471.12626529.3
3Display Results3473470.1232821.1
 (SQL Overall)1786913471.372130241.3
 
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.