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 “curtate” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

352 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
curtate931264(None) 
curate85226241cur_ate
aurate64426472aur_ate
aureate72515282aureate
bursate94111202bursate
carate84734002car_ate
cartage10312592cartage
cerate84829462cer_ate
cirrate92413492cirrate
citrate92216802citrate
cordate10315222cordate
corotate102813932corotate
costate94019272costate
crate76537402c_r_ate
create85126382c_reate
cultrate10310872cultrate
cuneate9311722cuneate
curare84916952cur_are
curated104717582cur_ated
curates95323832cur_ates
curette939782curette
curiae84518372curia_e
curite85222942cur_ite
curtail9299662curtail
curtain9319792curtain
curtal83914542curta_l
curtals93111622curtals
cuspate1138232cuspate
cuttage10318342cuttage
furcate12310452furcate
guttate8328902guttate
muriate9313362muriate
mutate83017482mu_tate
nutate63017372nu_tate
outate62923402ou_tate
outrate72323182outrate
scutate9310322scu_tate
urate55432162_ur_ate
accurate12410663accur_ate
acerate92818913acer_ate
acerbate1247533acerbate
acervate1336983acervate
acetate92514753acetate
acuate8315633acu__ate
aculeate1039923aculeate
aerate64830553aer_ate
agitate8312063agitate
airdate8311323airdate
aortae65115473aorta_e
aurae54128113aur_a_e
aurated83817793aur_ated
barbate11314543barbate
berate84729023ber_ate
bistate9313823bistate
borate85026153bor_ate
bullate93415073bullate
burette939853burette
burgage1136633burgage
burkite1337003burkite
bursae84515603bursa_e
butane8313653bu_tane
butte74924293bu_t_te
cantata93811813cantata
capitate121712183capitate
carafe115416163car_afe
carat75048793car_at_
carates95630613car_ates
carats85929023car_ats
carcase11312743carcase
caretake1446773caretake
carfare12310073carfare
carinate103320253carinate
carnage10311743carnage
carpale113414353carpale
cartable121314093cartable
cartages11313313cartages
carte75940423car__te
caseate9314783caseate
castrate10313863castrate
cate66254603c___ate
caudate10311353caudate
cavitate13159833cavitate
centare93113703centare
cerated103922473cer_ated
cerates95428253cer_ates
cerite84724873cer_ite
certain92612213certain
cetane8315283c_etane
chelate122914903chelate
cholate122114933cholate
chordate1448033chordate
chromate15312783chromate
ciliate9514603ciliate
citrated112712253citrated
citrates102315093citrates
clavate1238713clavate
climate11312833climate
coarctate1344823coarctate
cocreate122611813cocreate
cogitate1148553cogitate
cognate10312203cognate
collate92919683collate
comate104124843c_omate
connate9315753connate
cordage11310063cordage
cordite10315263cordite
corelate10516013corelate
corkage1438373corkage
cornute939643cornute
coronate103018213coronate
corotated122810053corotated
corotates112714283corotates
corrade101111043corrade
corsage1039803corsage
cortege1098953cortege
corticate13410773corticate
costae85319683costa_e
cottae84615703cotta_e
cottage104210573cottage
courage10310993cour_age
courante1049953courante
crake114823523c_r_ake
crane75331603c_r_ane
crape96128443c_r_ape
crated94827773c_r_ated
crater85026643c_r_ater
crates85736063c_r_ates
crave105626313c_r_ave
craze165221463c_r_aze
crease85519573c_rease
created104323453c_reated
creates95225203c_reates
cremate113816183cremate
crenate93317113crenate
cristate10310603cristate
croute84617273c_route
cruciate1287313cruciate
crusade1036053crusade
cubage1178273cu_bage
cuittle946403cuittle
culotte976893culotte
culpae10389263culpa_e
cultivate1447083cultivate
cultrated1248233cultrated
culture939393culture
cumulate123110223cumulate
cuneated11310103cuneated
cupcake1743953cupcake
cuprite1159683cuprite
cupulate122810033cupulate
curable112414513curable
curacy1339593cur_acy
curagh1236553cur_agh
curara83712203cur_ara
curares94916853cur_ares
curari84414403cur_ari
curative13310403curative
curator9312213curator
curbable1447663curbable
curdle95514313cur_dle
cure66149123cur___e
curet75447643cur_et_
curets84922343cur_ets
curettage1242353curettage
curetted1137173curetted
curettes1039313curettes
curia74523783curia__
curial84019153curia_l
curie74533043cur__ie
curites93919863cur_ites
currach1446453currach
curragh1344293curragh
curran8312023curra_n
currans9310613currans
currant9314173currant
currants1037933currants
currie84317263cur_rie
curse75829143cur__se
cursive1237833cursive
curst74931023cur_st_
curt67051713cur__t_
curtailed1244113curtailed
curtailer1143823curtailer
curtails10318243curtails
curtained1265503curtained
curtains10259703curtains
curtalax1742053curtalax
curter85320083curt_er
curtest9713963curtest
curtesy1265833curtesy
curtilage1243203curtilage
curtly1149283curt_ly
curtsey1255013curtsey
curtsied1134973curtsied
curtsies1038733curtsies
curtsy1156643curt_sy
curule83614123cur_ule
curvature1442793curvature
curve104920023cur__ve
curvet114720243curvet_
curveted1435293curveted
curvets12399913curvets
cushat113513693cushat_
cushats12288273cushats
cuspated1335913cuspated
custard10389973custard
cute66440453cu___te
cutie76925933cu_t_ie
cutlet84924363cu_tlet
cuttable1247953cuttable
cuttages11297223cuttages
cutter84521003cu_t_ter
cuttle84113893cu_ttle
cutty105417223cu_t_ty
cutwater1344833cutwater
cuvette1235833cuvette
cyanate12259703cyanate
dentate8315153dentate
derate74531233der_ate
dictate10311663dictate
ergate7315143_ergate
eructate1047333eructate
estate64719763_estate
fermate122813003fermate
ferrate103014043ferrate
formate123115093formate
furane94015493fur_ane
furcated1437593furcated
furcates1339883furcates
furnace1235943furnace
furtive1337173furtive
gestate83614073gestate
grate64932883_gr_ate
guttae73210583gutta_e
guttated10266873guttated
gyrate104912523gyr_ate
hastate10313913hastate
humate113214443hu_mate
hurtle93512943hurt_le
imitate9310873imitate
incurvate1446063incurvate
instate71616483instate
irate55627983_ir_ate
irritate867873irritate
jugate14379463ju_gate
jurat124829323jur_at_
jurats134213203jur_ats
karate105320923kar_ate
kurta95113913kurta__
kurtas10349883kurta_s
lactate9312703lactate
laureate888023laureate
lunate6316043lu_nate
lurdane835983lurdane
lustrate8310443lustrate
luxate1338083lu_xate
lyrate94112103lyr_ate
metate82720533_metate
muriated1139793muriated
muriates10312083muriates
muricate12311113muricate
mutase82811993mu_tase
mutated102712253mu_tated
mutates92215793mu_tates
narrate7313493narrate
nervate1039533nervate
nictate9310223nictate
nitrate72017013nitrate
notate63217863_notate
nurture736643nurture
nutated83113423nu_tated
nutates73214973nu_tates
ocreate93711743ocreate
orate55133303_or_ate
ornate6315143_ornate
outage72017533ou_tage
outdate83016423outdate
outrace92418553outrace
outrage82616893outrage
outrated92219323outrated
outrates82421373outrates
outrave102614413outrave
outstate81411993outstate
outtake11310793outtake
partake1339643partake
partite9317133partite
pectate112214693pectate
peltate92013773peltate
pirate82322883pir_ate
portage103013643portage
prate75135983_pr_ate
pulsate9510233pulsate
punctate1246473punctate
pupate104213123pu_pate
quate144521413qu__ate
quinate16511573quinate
rate45458763__r_ate
recurvate1445853recurvate
restate73824883restate
rotate63320343_rotate
rugate75813813ru_gate
ruinate7312833ruinate
scutage1036333scu_tage
septate9511873septate
seriate73722473seriate
serrate73017543serrate
sorbate9311733sorbate
state56237333__state
striate74218953striate
sublate9315363sublate
substate101711093substate
sulcate9314423sulcate
sulfate10311653sulfate
summate113611663summate
surbase939793surbase
surface1238653surface
suricate10312613suricate
surname937603surname
surtax1337843surta_x
surtaxed1644143surtaxed
surtaxes1536513surtaxes
surtitle845283surtitle
tartare73012683tartare
tartrate899693tartrate
tate44748603___tate
ternate7415483ternate
testate73916233testate
titrate72215573titrate
tubate82813173tu_bate
turgite837973turgite
turtle63213573turt_le
unstate71916213unstate
untame82513603_untame
update93810293_update
uprate83916543_uprate
upstate91610493upstate
uptake1236963_uptake
urare56322553_ur_are
urase54624693_ur_ase
urates65027763_ur_ates
urbane82211383_urbane
urease64516993_urease
urinate7315363_urinate
ursae55214453_ursa_e
urticate1049863_urticate
variate101316433variate
virgate1138733virgate
vittate10409733vittate
vulgate11388433vulgate
vulvate13388323vulvate
wurtzite2042003wurtzite
yurta86014253yurta__

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340273526.43620824.6
3Display Results3523520.1562256.4
 (SQL Overall)1786913526.99825534.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.