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

222 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
cried8462429(None) 
caried94528691caried
cred76530881cr_ed
creed85727391creed
crier74724461crier
cries75438401cries
dried75321381dried
fried95322911fried
pried84426861pried
scried95817311scried
tried65026911tried
wried95518561wried
acred87126352acr_ed
acrid86920102acri_d
aeried74221872aeried
aired66032922aired
arced88224162arced
arid57642712ari_d
ariel55228972ariel
ariled75620322ariled
armed86324432armed
bred75130972br_ed
breed85526692breed
bribed115312842bribed
bride86425532bride
brie65837902brie_
brief105422602brief
brier74527402brier
bries74942152bries
brined95118412brined
buried94822372buried
caged95426362caged
caid77837532cai_d
caird85717232caird
caked126128622caked
caned85838092caned
caped104931802caped
carded105424902carded
cared86050092cared
caries85147622caries
carked134024822carked
carped115923762carped
carried103717152carried
carted98631442carted
carved124320852carved
cased86032412cased
caved116227562caved
cawed116627062cawed
ceded96118562ceded
ceiled94114952ceiled
cered85227442cered
chid106626402chi_d
chide115321012chide
chided135113962chided
chief134419482chief
chiel104918972chiel
chield124610212chield
child114516222child
chimed145814832chimed
chined125620062chined
cire65836372cire_
cires74932912cires
cited84421952cited
citied94014142citied
clued84917682clued
coded95433182coded
coed77140542c_oed
coifed124113062coifed
coiled95123942coiled
coined94523602coined
coked124730692coked
coled85540762coled
coned86040052coned
cooed84534342cooed
coped105036852coped
copied114618572copied
corded105923352corded
cored85044222cored
corked135020782corked
corned95224522corned
cosied94819892cosied
coted85033852coted
coved115027372coved
cowed115637852cowed
coxed154322812coxed
coyed114623802coyed
cozied184112162cozied
craned96121652craned
craped116120532craped
crated94827772crated
craved125417772craved
crazed184714452crazed
credo84815572cr_edo
creds85418772cr_eds
creeds94714772creeds
creek114917392creek
creel75121482creel
creep95218102creep
creped114115712creped
crew96122682cr_ew
crewed125316562crewed
crib86323582cri_b
cribbed14407662cribbed
cribs94516752cribs
crick135118752crick
cricked164814282cricked
criers83918582criers
crikey15317782crikey
crime94822692crime
crimes105521582crimes
crimp115615802crimp
crimped143910762crimped
cringed113312402cringed
cripe95521142cripe
cripes105120872cripes
cris66233432cri_s
crises84529432crises
crisp95014622crisp
crisped124010112crisped
crit65743712cri_t
crits75527572crits
crowd115815622crowd
crowed124717312crowed
crud75219612cr_ud
crude86018572crude
cruel74815902cruel
cruet74831842cruet
cruised103710222cruised
cubed105519702cubed
cued76329562c_ued
curbed114615872curbed
curded104217162curded
cured85932132cured
curie74533042curie_
curies84934022curies
curled95021652curled
curred94319262curred
curried103313652curried
cursed94321252cursed
curved124815222curved
decried112612862decried
died66137852_died
dreed75222842dreed
drier64423962drier
dries64733672dries
erred65915672erred
fired94829742fired
flied96519432flied
freed95223542freed
friend10388932friend
frier85225842frier
fries85535602fries
frized193510682frized
gied64631982_gied
greed75125692greed
grid65829612gri_d
gride75223582gride
grided95117042grided
grief95319782grief
grimed104714092grimed
grind75917562grind
griped104114712griped
hied85434042_hied
hired95226262hired
ired55131872ir_ed
irid55927172iri_d
irised73913152irised
irked104510922irked
ivied94710522ivied
juried144212442juried
lied55838092_lied
mired85729222mired
orbed85516192orbed
oriel54920422oriel
pied75035362_pied
plied85118592plied
preed85128122preed
priced115018882priced
pride84724732pride
prided103618032prided
prier75027762prier
pries74339532pries
primed115118912primed
prised94322202prised
prized184415392prized
red46755802_r_ed
reed55549622_reed
riced85825542_riced
rid46754632_ri_d
ride55945132_ride
riel46432382_riel
riled65833252_riled
rimed84826372_rimed
rind56535602_rind
riped85226432_riped
rived94825612_rived
rued55729792_rued
screed95718932screed
scribed124510642scribed
scries85226822scries
scrived134511112scrived
shied96125492shied
sired66134282sired
skied104417752skied
spied85427712spied
stied65723032stied
tied55535212_tied
tired65228902tired
treed65626732treed
triad65217722triad
triced95518672triced
trier54328532trier
tries55742812tries
trined74920712trined
trued65117692trued
urged75316032urged
urped84615282urped
varied104817862varied
vied86328632_vied
wired95327642wired
wrier84521752wrier
wries85827742wries

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.313570897.8
2DLD Change Limit538002221.64032804.9
3Display Results2222220.0633523.8
 (SQL Overall)1786912222.01688636.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.