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

214 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
creed8572739(None) 
breed85526691breed
cered85227441cered
cred76530881cr_ed
creeds94714771creeds
creek114917391creek
creel75121481creel
creep95218101creep
creped114115701creped
crewed125316561crewed
cried84624281cried
dreed75222841dreed
freed95223541freed
greed75125691greed
preed85128121preed
reed55549621_reed
screed95718931screed
treed65626731treed
acred87126352acr_ed
agreed84712502agreed
arced88224162arced
armed86324432armed
bleed85019802bleed
bread85523112bread
bred75130972br_ed
brede85520502brede
bree67241262bree_
breeds94914882breeds
brees75632552brees
brewed125411872brewed
caged95426362caged
caked126128622caked
caned85838092caned
caped104931802caped
carded105424902carded
cared86050092cared
careen84119492careen
career85822242career
caried94528692caried
carked134024822carked
carped115923762carped
carted98631442carted
carved124320852carved
cased86032412cased
caved116227562caved
cawed116627062cawed
cede74928772c_ede
ceded96118562ceded
cee55952702c_ee_
cees65941592c_ees
cere66741472cere_
ceres75540012ceres
cheek145115712cheek
cheep125416502cheep
cheer105420382cheer
chefed155010562chefed
chewed154415012chewed
cited84421952cited
cleek115514912cleek
cleped115114112cleped
clewed1225113202clewed
clued84917682clued
coded95433182coded
coed77140542c_oed
coked124730692coked
coled85540762coled
coned86040052coned
cooed84534342cooed
cooeed95917862cooeed
coped105036842coped
corded105923352corded
cored85044222cored
corked135020782corked
corned95224522corned
coted85033852coted
coved115027372coved
cowed115637852cowed
coxed154322812coxed
coyed114623802coyed
craned96121652craned
craped116120522craped
crated94827772crated
craved125417772craved
crazed184714452crazed
creak115418432creak
creaked143413232creaked
cream95721352cream
creamed123913712creamed
creased104315582creased
created104323452created
credo84815572credo
creds85418772creds
creedal1037092creedal
creeks124812922creeks
creeled104012012creeled
creels84416942creels
creeped12329712creeped
creeps104213622creeps
creepy13418802creepy
creese84014332creese
creesh11328332creesh
creme94319322creme
cremes104517992cremes
crenel84213062crenel
crepe95520722crepe
crepes105419342crepes
crepey135110932crepey
crept95125892crept
crepy124812702crepy
cress75022832cress
crest74632692crest
crested103416532crested
crew96122682cr_ew
crewel114310482crewel
crews105917502crews
crier74724462crier
cries75438402cries
crowd115815622crowd
crowed124717302crowed
crud75219612cr_ud
crude86018572crude
cruel74815902cruel
cruet74831842cruet
cubed105519702cubed
cued76329562c_ued
curbed114615872curbed
curded104217162curded
cured85932132cured
curled95021652curled
curred94319262curred
cursed94321252cursed
curved124815222curved
decreed112710252decreed
deed65340902_deed
dread74419022dread
dree56638322dree_
drees65628522drees
dried75321382dried
erred65915672erred
feed84538902_feed
free75940182free_
freer86021242freer
frees86131392frees
fremd115010322fremd
fried95322912fried
geed65435502_geed
gleed75320572gleed
gree56641562gree_
greeds84314282greeds
greedy11518852greedy
greek105915942greek
green65522142green
grees65132472grees
greet65835322greet
greyed114610602greyed
heed86437602_heed
ired55131872ir_ed
irked104510922irked
jeed125428502_jeed
jereed144012072jereed
kneed104612052kneed
kreep114610412kreep
meed74934702_meed
need54934152_need
orbed85516192orbed
oread64619602oread
peed76239182_peed
pree67044732pree_
preen75925052preen
prees75937172prees
premed114617762premed
preyed125313202preyed
pried84426862pried
pureed95017812pureed
read55942532_read
red46755802_r_ed
redd66323172_redd
rede55037672_rede
reded74829122_reded
ree37974072_ree_
reeds65430902_reeds
reedy910020292_reedy
reef74938212_reef
reek85232522_reek
reel45240532_reel
rees45364192_rees
refed93921922_refed
rend56136572_rend
rewed95425452_rewed
rued55729792_rued
scree720031712scree_
screeds106210292screeds
screen85216022screen
screes85023972screes
screwed135710662screwed
scried95817302scried
seed55549482_seed
sered65737292sered
skeed105018982skeed
speed85526622speed
steed66024942steed
teed55439262_teed
tread64821702tread
tree47745812tree_
treen55622752treen
trees55835762trees
trend64817452trend
tried65026912tried
trued65117692trued
tweed94915092tweed
urged75316032urged
urped84615282urped
weed85637512_weed
wried95518562wried

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 Filter178691538000.343520965.0
2DLD Change Limit538002141.44037361.1
3Display Results2142140.0603566.7
 (SQL Overall)1786912141.84396956.6
 
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.