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

326 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
aureate7251528(None) 
aurate64426471aur_ate
laureate888021laureate
acerate92818912acerate
acreage1037832acreage
aculeate1039912aculeate
aerate64830552aer_ate
airdate8311322airdate
areae55229742a_rea_e
arete56031352a_re_te
aurae54128112aur_a_e
aurated83817792aur_ated
aureately1244382aureately
aureole738692aureole
burette939852burette
bursate94111202bursate
create85126372_create
cuneate9311722cuneate
curate85226242cur_ate
curette939782curette
curtate9312642curtate
furcate12310452furcate
laureated1096152laureated
laureates987682laureates
muriate9313362muriate
nauseate845892nauseate
ocreate93711742ocreate
urate55432162_ur_ate
urease64516992_urease
abate76627843a__bate
ablate82219213a_blate
ablegate1147253ablegate
abnegate1144863abnegate
abrade9313053abr_ade
abreact11310823abreact
abreacted1444293abreacted
abreacts1245633abreacts
abreast9311273abreast
abrogate11129603abrogate
accrete1137843accre_te
accurate12410663accur_ate
acerated113113983acerated
acerbate1247533acerbate
acervate1336983acervate
acetate92514753acetate
acierate10311813acierate
acreages1138363acreages
acrylate1347693acrylate
actuate9311443actuate
acuate8315633a_cuate
aculeated1247713aculeated
acylate12310533acylate
adnate72913483a_dnate
adulate8313233adulate
aduncate1145573aduncate
aerated85322373aer_ated
aerates74627483aer_ates
afreet9315153afreet_
afreets1037013afreets
agate66525143a__gate
agemate101210583agemate
aggregate1244203aggregate
agitate8312063agitate
agnate73314873a_gnate
agrafe1038093agr_afe
agree65226033agre__e
aguacate1144963aguacate
aigrette946833aigrette
airdates939713airdates
airest63825263airest_
airfare1047243airfare
airwave1344433airwave
alate55340323a__late
alienate8311553alienate
already1144263already
ameerate1039633ameerate
amirate91115953amirate
amreeta945163amreeta
animate91617213animate
ansate64517863a_nsate
anteater8311603anteater
antedate949683antedate
aortae65115473aorta_e
appease1137913appease
arame75026623a_r_ame
arbute8311043a_rbute
arcade91013643a_rcade
arcane81216743a_rcane
arcuate9311963arcuate
area45843393a_rea__
areal55928733a_rea_l
areas55935773a_rea_s
arene55329413a_re_ne
arenite71017713a_renite
areolate81014453a_reolate
areole61017283a_reole
aretes64425353a_re_tes
arhat8327093a_rhat_
arhats9312973a_rhats
ariette7312373ariette
arrear6310253arrea_r
arrears738843arrears
arrest63722633arrest_
arrested939153arrested
arrestee849433arrestee
arrester839253arrester
arrests73312683arrests
arrogate91210323arrogate
arsenate81010483arsenate
asperate10312373asperate
aubade939223au_bade
auberge1045633auberge
augite7312613au_gite
aura45836253aur_a__
aural54428963aur_a_l
aurar54420253aur_a_r
auras55932553aur_a_s
aurei54821863aure__i
aureola747033aureola
aureolae845313aureolae
aureoled945733aureoled
aureoles838283aureoles
aures55137093aure__s
aureus65314883aure_us
auricle9139813auricle
aurist65027253aurist_
aurists74615783aurists
aurorae739663aurorae
automate10411943automate
average1158853average
aviate9315203a_viate
azurite1638003azur_ite
barbate11314543barbate
barrette1039783barrette
berate84729023ber_ate
bereave1258353bereave
borate85026153bor_ate
breath113916263_breath
breathe123711843_breathe
bullate93415073bullate
bureau8712523burea_u
bureaus979283bureaus
bureaux1664593bureaux
buret77444013bure_t_
burets84321263bure_ts
burettes1048943burettes
burgage1136633burgage
burkite1337003burkite
bursae84515603bursa_e
calceate1239863calceate
carate84734003car_ate
caseate9314783caseate
caudate10311353cau_date
cerate84829463cer_ate
cirrate92413483cirrate
cocreate122611813cocreate
cordate10315213cordate
corelate10516013corelate
crate76537403_cr_ate
crease85519573_crease
created104323443_created
creates95225173_creates
cremate113816183_cremate
crenate93317113_crenate
cuneated11310103cuneated
curare84916953cur_are
curated104717583cur_ated
curates95323823cur_ates
curet75447643cure_t_
curets84922343cure_ts
curetted1137173curetted
curettes1039313curettes
curiae84518373curia_e
curite85222943cur_ite
cuspate1138233cuspate
cuvette1235833cuvette
derate74531233der_ate
ergate7315143_ergate
fermate122813003fermate
ferrate103014033ferrate
foredate12310913foredate
formate123115093formate
foveate1338363foveate
fumette1245523fumette
furane94015493fur_ane
furcated1437593furcated
furcates1339873furcates
furnace1235943furnace
galeate83916783galeate
grate64932883_gr_ate
grease75416233_grease
great66034243_great_
greaten83610643_greaten
greater84416493_greater
greats76318393_greats
greave104611493_greave
guttate8328903guttate
gyrate104912523gyr_ate
hereat93527413hereat_
humate113214443hu_mate
ideate7313683_ideate
increate10312203increate
irate55627983_ir_ate
iterate71119103iterate
jugate14379463ju_gate
jurat124829323jur_at_
jurats134213203jur_ats
karate105320923kar_ate
lacerate102214703lacerate
laurae64011663laur_a_e
lineate7815153lineate
lunate6316043lu_nate
lunette737483lunette
lurdane835983lurdane
luxate1338083lu_xate
lyrate94112103lyr_ate
macerate122314073macerate
maleate94117543maleate
maturate10312613matur_ate
muriated1139793muriated
muriates10312083muriates
muricate12311113muricate
musette938433musette
mutate83017483mu_tate
narrate7313493narrate
nauseated1045233nauseated
nauseates946213nauseates
nervate1039523nervate
nucleate1048673nucleate
numerate101610393numerate
nutate63017373nu_tate
ocreae83310273ocrea_e
oleate6318883_oleate
operate9615733operate
orate55133303_or_ate
ornate6315133_ornate
outate62923403ou_tate
outdate83016423outdate
outeat62824533outeat_
outeaten8310423outeaten
outeats72215703outeats
outrate72323183outrate
overate10620963overate
paleate94120003paleate
patriate10311933patriate
permeate12311603permeate
pileate93815923pileate
pirate82322883pir_ate
prate75135983_pr_ate
predate10616893_predate
prelate9519693_prelate
pulsate9510233pulsate
pupate104213123pu_pate
puree74632843pure__e
purest84021933purest_
quate144521413qu__ate
quinate16511573quinate
rate45458763__r_ate
reata54225393__reata
reave84528023__reave
rebate84424103__rebate
recreate10313603recreate
redate74124683__redate
relate64033633__relate
remate84428683__remate
rente54733783__rente
rete44944133__re_te
roseate7613453roseate
rugate75813813ru_gate
ruinate7312833ruinate
saturate8312813satur_ate
serenate81914873serenate
seriate73722473seriate
serrate73017533serrate
sorbate9311733sorbate
strette7310763strette
striate74218953striate
sublate9315363sublate
sulcate9314423sulcate
sulfate10311653sulfate
summate113611663summate
surbase939793surbase
surcease1086883surcease
surest65026763surest_
surety93515003sure_ty
surface1238653surface
suricate10312613suricate
surname937603surname
syrette1037183syrette
terete6319333tere_te
ternate7415483ternate
threat95020463threat_
threated1259203threated
threaten1146303threaten
threats104311673threats
treat56240353_treat_
treated83618703_treated
treater74219833_treater
treats64821693_treats
treaty94414353_treaty
tubate82813173tu_bate
turgite837973turgite
uncreate10311353uncreate
unease63816643_unease
uneaten7412543_uneaten
update93810293_update
uprate83916543_uprate
urare56322553_ur_are
urase54624683_ur_ase
urates65027763_ur_ates
urbane82211383_urbane
urea46528053_urea__
ureal56722683_urea_l
ureas55826013_urea_s
ureases74416723_ureases
ureide7310363_ureide
ureter6313203_ure_ter
urinate7315363_urinate
ursae55214453_ursa_e
valerate11311463valerate
variate101316433variate
virgate1138733virgate
vulgate11388433vulgate
vulvate13388323vulvate
wreath124111193_wreath
wreathe13339053_wreathe

Search took 9 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.1561145455.1
2DLD Change Limit1340273268.34316064.6
3Display Results3263260.2331399.1
 (SQL Overall)1786913268.73220463.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.