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

208 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
curette93978(None) 
burette939851burette
curetted1137171curetted
curettes1039311curettes
cuvette1235831cuvette
aureate72515282aureate
burettes1048952burettes
casette9310392casette
corvette1338092corvette
courgette1244522courgette
create85126382c_reate
culotte976892culotte
cuneate9311722cuneate
curate85226242cur_ate
curet75447642cure_t_
curets84922342cure_ts
curettage1242352curettage
curite85222942cur_ite
curtate9312642curtate
curvetted1543702curvetted
cuvettes1335322cuvettes
fumette1245522fumette
lunette737482lunette
musette938432musette
strette7310762strette
syrette1037182syrette
accrete1137843accre_te
aculeate1039923aculeate
aigrette946833aigrette
arete56031353_are_te
ariette7312373ariette
aurate64426473aur_ate
aureole738693aureole
barbette1249113barbette
barrette1039783barrette
beretta938463beretta
biretta947243biretta
brunette1044723brunette
buret77444013bure_t_
burets84321263bure_ts
burkite1337003burkite
bursate94111203bursate
butte74924293bu__tte
cabretta1244843cabretta
calotte9510563calotte
carate84734003car_ate
caret75360563care_t_
caretake1446773caretake
carets85330773care_ts
carte75940423car__te
caseate9314783caseate
casettes1039653casettes
cassette1047813cassette
cavetti1245423cavetti
cavetto1245453cavetto
celeste949653celeste
cerate84829463cer_ate
cerite84724873cer_ite
cete64934783c__e_te
chaetae1238603chaetae
cigarette1243783cigarette
cirrate92413493cirrate
cocotte1138603cocotte
cocreate122611813cocreate
coquette1976593coquette
cordate10315223cordate
cordite10315263cordite
corelate10516013corelate
cornute939643cornute
corotate102813933corotate
cortege1098953cortege
corvettes1447433corvettes
couchette1644913couchette
courante1049953courante
courgettes1344123courgettes
crate76537403c_r_ate
crease85519573c_rease
created104323453c_reated
creates95225203c_reates
creche13310763c_reche
creese84014333c_reese
cremate113816183c_remate
creme94319323c_re_me
crenate93317113c_renate
creole8913733c_reole
crepe95520723c_re_pe
crept95125893c_rept_
crest74632693c_rest_
crested103416533c_rested
crests85218703c_rests
cretic102816283c_retic
cretin82917913c_retin
critter94113033c_ritter
croute84617273c_route
cruelty1234113cruelty
cruet74831843crue_t_
cruets85314953crue_ts
cuesta838513cu_esta
cuittle946403cuittle
culet76040343cule_t_
culets85518513cule_ts
culottes1076293culottes
cuneated11310103cuneated
cuprite1159683cuprite
curable112414513curable
curare84916953cur_are
curated104717583curated
curates95323833curates
curative13310403curative
curator9312213curator
curdle95514313cur_dle
cure66149123cur___e
cured85932133cure__d
curer75030753cure__r
curers84923193cure_rs
cures75645433cure__s
curettages1342353curettages
curetting1236573curetting
curiae84518373cur_iae
curie74533043cur__ie
curites93919863curites
current9313693current_
currents1038373currents
currie84317263cur_rie
curse75829143cur__se
cursive1237833cursive
curst74931023cur_st_
curt67051713cur__t_
curtal83914543cur_tal
curter85320083cur_ter
curtest9713963curtest
curtesy1265833curtesy
curtly1149283cur_tly
curtsey1255013cur_tsey
curtsy1156643cur_tsy
curule83614123cur_ule
curve104920023cur__ve
curvet114720243curvet_
curveted1435293curveted
curvets12399913curvets
cuspate1138233cuspate
cute66440453cu___te
cutesie937963cutesie
cutest85820143cutest_
cutie76925933cu__tie
cutter84521003cu__tter
cuttle84113893cu_ttle
cutty105417223cu__tty
cuvee10316143cuve__e
dinette8310013dinette
duetted937023du_etted
fouette1038213fouette
fretted113411853_fretted
fretter103412753_fretter
fretty1249223_fretty
fumettes1345773fumettes
furcate12310453furcate
galette84212693galette
garotte868703garotte
gazette17357363gazette
genette838863genette
hurtle93512943hur_tle
laureate888023laureate
layette1037133layette
lunettes836753lunettes
mofette1296773mofette
mozette1886773mozette
muriate9313363muriate
musettes1037433musettes
navette1036983navette
ocreate93711743ocreate
octette946423octette
palette93613983palette
parkette14138023parkette
pipette1137943pipette
pretty11510873_pretty
proette9312363proette
puree74632843pure__e
purest84021933purest_
quartette1843963quartette
rente54733783__rente
rete44944133__re_te
retie55735303__retie
retted74826313__retted
rosette7310373rosette
rotte54625933__rotte
roulette847093roulette
soubrette1143993soubrette
stretta737293stretta
stretti747913stretti
stretto737733stretto
superette1149973superette
surest65026763surest_
sureties8316583sureties
surety93515013sure_ty
syrettes1136963syrettes
terete6319333tere_te
tonette7310373tonette
turgite837973turgite
turtle63213573tur_tle
umbrette1244943umbrette
urate55432163_ur_ate
urease64516993_urease
ureide7310363_ureide
ureter6313203_ureter
uretic82914353_uretic
vedette1166003vedette
vidette1167543vidette

Search took 7 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 Limit1340272086.15621771.8
3Display Results2082080.0802600.0
 (SQL Overall)1786912086.64226903.2
 
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.