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

219 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
crated9482777(None) 
carted98631441carted
cerated103922471cerated
coated94927041coated
crafted13419771crafted
craned96121651craned
craped116120521craped
crate76537401crate_
crater85026641crater
crates85736061crates
craved125417771craved
crazed184714451crazed
created104323451created
curated104717581curated
grated84523921grated
orated74221501orated
prated94924921prated
rated65441381_rated
abated95918452abated
acerated113113982acerated
aerated85322372aerated
alated75625142alated
aurated83817792aurated
bated85935532_bated
berated104422132berated
boated94221972boated
borated104116362borated
braced115420602braced
bracted12410932bracted
braked135318692braked
braved124817442braved
brayed124615782brayed
brazed184717082brazed
bruted95113262bruted
caged95426362c_aged
caked126128622c_aked
caned85838092c_aned
canted94825782canted
caped104931802c_aped
carate84734002carate_
carates95630612carates
carded105424902carded
cared86050092c_ared
caried94528692caried
carked134024822carked
carped115923762carped
carte75940422carte_
cartel85022532cartel
carter84932272carter
cartes86239472cartes
carved124320852carved
cased86032412c_ased
cate66254602c_ate_
cater74840722c_ater
cates75951892c_ates
catted95422472catted
caved116227562c_aved
cawed116627062c_awed
ceased94920782ceased
cerate84829462cerate_
cerates95428252cerates
chafed154813912chafed
chanted134015952chanted
chared125423692chared
charted135116852charted
chased125019292chased
chatted133411892chatted
chawed155214602chawed
cheated134416342cheated
chuted124611842chuted
cisted95217522cisted
cited84421952c_ited
citrated112712252citrated
clawed125115072clawed
clayed125013042clayed
cleated103417842cleated
coacted123611612coacted
coaled95022712coaled
coapted123911502coapted
coasted104015952coasted
coatee84327222coatee
coater84329572coater
coaxed165612512coaxed
costed95623112costed
coted85033852c_oted
craaled10339422craaled
crabbed14388872crabbed
cracked163514742cracked
cradled113410812cradled
crafter124111332crafter
cragged12479882cragged
crake114823522crake_
crakes124921812crakes
crammed143710122crammed
cramped144712182cramped
crane75331602crane_
cranes84330752cranes
cranked143812842cranked
crape96128442crape_
crapes104727692crapes
crapped143912622crapped
crases85532312crases
crashed134214202crashed
cratch134110792cratch
cratered1149682cratered
craters95021892craters
craton84517192craton
crave105626312crave_
craven114113932craven
craver114618472craver
craves115825392craves
crawled133710402crawled
craze165221462craze_
crazes174720132crazes
creaked143413232creaked
creamed123913712creamed
creased104315582creased
create85126382create_
creates95225202creates
cred76530882cr__ed
creed85727392cr_eed
cremated133412962cremated
crenated113013912crenated
creped114115702creped
crested103416532crested
crewed125316562crewed
cried84624282cr_ied
croaked143710532croaked
crowed124717302crowed
crusted103712752crusted
curate85226242curate_
curates95323832curates
darted84620922darted
dated75530992_dated
derated93623502derated
doated84118182doated
drafted12439032drafted
draped105314362draped
dratted9358592dratted
drayed115911392drayed
elated74725822elated
erased74816752erased
farted105121782farted
fated95632132_fated
fracted1339372fracted
framed125116522framed
frater94520592frater
frayed135012162frayed
gated75329772_gated
graced105217902graced
graded94919552graded
grafted124110222grafted
granted94715102granted
grate64932882grate_
grater74625442grater
grates75429892grates
graved114818812graved
grayed115415642grayed
grazed174115912grazed
gyrated12428412gyrated
hated95734022_hated
heated104525592heated
irate55627982irate_
irater65218352irater
krater104014312krater
lated65240672_lated
lyrated11388472lyrated
marted94425212marted
mated85537782_mated
meated94222402meated
moated94819002moated
orate55133302orate_
orates64328612orates
parted94228682parted
pated85237842_pated
picrated132110112picrated
pirated102515612pirated
plated95225772plated
prate75135982prate_
prater84825352prater
prates84633162prates
prayed124815432prayed
raced87635312_raced
rafted104714702_rafted
raged74829452_raged
raked105831422_raked
ranted74324702_ranted
raped85334622_raped
rared65738322_rared
rased65033932_rased
rate45458762_rate_
ratel54224882_ratel
rater54943282_rater
rates55352012_rates
ratted74923342_ratted
raved94931432_raved
raxed135622662_raxed
rayed95127502_rayed
razed155027982_razed
recrated112918602recrated
sated66238532_sated
scarted104816122scarted
scraped124313132scraped
seated75131062seated
skated114414882skated
slated75028312slated
stated75427832stated
tarted74923372tarted
teated74924022teated
traced94821582traced
traded85717682traded
treated83618702treated
uncrated11416312uncrated
unrated82621552unrated
uprated103213322uprated
urate55432162urate_
urates65027762urates
warted104223232warted
wrathed14298522wrathed

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825512192.79629524.7
3Display Results2192190.0633476.2
 (SQL Overall)1786912193.20255806.1
 
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.