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

330 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
cremated13341296(None) 
created104323451cre_ated
cremate113816181cremate_
cremates124216001cremates
crenated113013911crenated
remated103522471_remated
bromated1339172bromated
casemated1446952casemated
cerated103922472c_erated
cheated134416342che_ated
chelated142610482chelated
cleated103417842cle_ated
coempted1535332coempted
corelated12411822corelated
crated94827772cr__ated
creaked143413232cre_aked
creamed123913712cre_amed
creased104315582cre_ased
create85126382cre_ate_
creates95225202cre_ates
credited1238252credited
cremator1269192cremator
crenate93317112crenate_
crested103416532cre_sted
crewmate15405632crewmate_
crewmates16375802crewmates
predated12513272predated
rebated103619702_rebated
redated93120922_redated
related83327572_related
remate84428682_remate_
remates93827112_remates
treated83618702tre_ated
acerated113113983acerated
acerbated1465553acerbated
acetated112010683acetated
acierated1238283acierated
aerated85322373_aerated
agemate101210583agemate_
agemates111110023agemates
animated111612373animated
arcuated1138803arcuated
areolated1089713areolated
belated103520013_belated
berated104422133_berated
bleated104015973ble_ated
breaded115014063bre_aded
breamed124011593bre_amed
breasted1138823breasted
breathed14469643bre_athed
bregmate1345533bregmate_
breveted1435623breveted
bromate11313553bromate_
bromates12413143bromates
carinated123414273carinated
caseated11310713caseated
casemate1239843casemate_
casemates1349523casemates
catenated1238913catenated
caudated1238063caudated
caveated1439133caveated
ceased94920783c_e_ased
cemented1338373c_emented
cerate84829463c_erate_
cerates95428253c_erates
cerebrated1546343cerebrated
cheater124816963che_ater
checkmated2452543checkmated
chelate122914893chelate_
chelates132713843chelates
chested133811673che_sted
chromate15312783chromate_
chromates16313113chromates
chromatid17410913chromatid
ciliated11510953ciliated
citrated112712253citrated
cleaned103512003cle_aned
cleared103612463cle_ared
cleaved134010483cle_aved
clefted13326753cle_fted
clematis1248653clematis
climate11312833climate_
climates12311973climates
climaxed2043113climaxed
coated94927043c__oated
cocreated142710093cocre_ated
coedited1237833coedited
coenacted1445803coenacted
coequated2144823coequated
collated113615063collated
comate104124843c_omate_
comates114123643c_omates
combated1539823combated
commuted15288983commuted
compted143813523c_ompted
copemate1439993copemate_
copemates1549483copemates
corelate10516013corelate_
corelates11314863corelates
coronated123313323coronated
corotated122810053corotated
correlated1346683correlated
craaled10339423cr_aaled
crafted13419773cr_afted
crammed143710123cram_med
cramped144712183cram_ped
craned96121653cr__aned
craped116120523cr__aped
crate76537403cr__ate_
crater85026643cr__ater
crates85736063cr__ates
craved125417773cr__aved
crazed184714453cr__azed
creamer113714093cre_amer
creamier12319063creamier
crease85519573cre_ase_
creaser94415743cre_aser
creases94020963cre_ases
creatin93618133cre_atin
creator93714443cre_ator
creed85727393cre___ed
creeled104012013cre_eled
creeped12329713cre_eped
creeshed1435693creeshed
cremains1238693cremains
cremating14312203cremating
cremation13511643cremation
cremators1369823cremators
crematory1647213crematory
creme94319323crem__e_
cremes104517993crem__es
crenately1444783crenately
crenelated1375363crenelated
creneled11326893creneled
crenulated1356043crenulated
creosoted1244043creosoted
creped114115703cre__ped
crepitated1584743crepitated
crevassed1543203crevassed
creviced1634453creviced
crewed125316563cre__wed
criminated1546823criminated
crimped143910763crim_ped
crimpled15366933crimpled
crispated1445023crispated
cristated1247423cristated
croaked143710533cr_oaked
crumbed14378473crum_bed
crumbled15357443crumbled
crumped144311223crum_ped
crumpled15296873crumpled
crusaded1244233crusaded
crusted103712753cr_usted
cuneated11310103cuneated
curated104717583c_urated
curetted1137173cure_tted
cuspated1335913cuspated
debated113916083_debated
delated93722873_delated
demasted1238763_demasted
demoted114313543_demoted
derated93623503_derated
dreaded103612023dre_aded
dreamed114310633dre_amed
elated74725823__elated
elevated12118293elevated
emoted94614923__emoted
erected103213993ere_cted
eremite9312833eremite_
eremites10312603eremites
exempted2044143exempted
fermate122813003fermate_
foredated1447683foredated
freaked15399703fre_aked
fretted113411853fre_tted
gelated93615643_gelated
gemmated14336293gemmated
gradated1157433gradated
grated84523923gr__ated
greased93812393gre_ased
greaten83610643gre_aten
greater84416493gre_ater
greaved12408913gre_aved
greeted93111383gre_eted
grimaced1463313grimaced
heated104525593_he_ated
ideated9310973ide_ated
iterated91213823iterated
legated92513983_legated
mated85537783___mated
meated94222403_me_ated
mismated131111333mismated
negated93413233_negated
ocreate93711743ocre_ate_
operated11512223operated
orated74221503or__ated
palmated132511003palmated
permeated1439373permeated
permuted1336713permuted
pleated103816633ple_ated
prated94924923pr__ated
preacted132710943preacted
preaged11612333pre_aged
prebaked1737173prebaked
precited133013813precited
predate10616893predate_
predates11615813predates
preempted1644683preempted
prefaced1638423prefaced
prefaded1537823prefaded
preheated1539813preheated
prelate9519693prelate_
prelates10418573prelates
premade12311443premade_
premed114617763prem__ed
premised133013193premised
premixed20338013premixed
prepared132210873prepared
prepasted14137673prepasted
prepaved16177233prepaved
presaged1238803presaged
pretaped13339133pretaped
pretasted12147963pretasted
primate111516283primate_
primates121515933primates
probated13410863probated
promoted13310543promoted
prompted1536903prompted
pronated11414053pronated
prorated11513713prorated
ramate83921693_ramate_
rated65441383_r__ated
reacted103015713_reacted
reamed94326123_re_amed
reaped94122453_re_aped
reared75930013_re_ared
reaved104523923_re_aved
rebaited11410543_rebaited
rebate84424113_rebate_
rebater93517913_rebater
rebates95123183_rebates
recaned102817203_recaned
recanted112513513_recanted
recited104319103_recited
recoated113416783_recoated
recrated112918603_recrated
recreated12412533recre_ated
redacted12410243_redacted
redate74124683_redate_
redates83423873_redates
reested82916233_reested
refaced133713573_refaced
reflated123514293_reflated
refuted114313803_refuted
regaled93615963_regaled
regrated102816333_regrated
reheated122415003_reheated
reimaged1246173_reimaged
relaced103517213_relaced
relate64033633_relate_
relater73723143_relater
relates73731433_relates
relaxed153312533_relaxed
relayed113212753_relayed
remade94316983_remade_
remailed112411403_remailed
remained112412893_remained
remake124016113_remake_
remaker133813173_remaker
remakes134116173_remakes
remand95618963_rema_nd
remanded123011323_remanded
remanned11319353_remanned
remapped1534913_remapped
remarked15209243_remarked
remaster10311473_remaster
rematch1436193_rematch
rematched1745223_rematched
remelted11310153_remelted
reminted113615083_reminted
remised103516843_remised
remitted113312073_remitted
remixed173510743_remixed
remote84222603_remote_
remoter94815973_remoter
remotes94521613_remotes
removed134611313_removed
renamed103114523_renamed
rented74426593_re_nted
repasted112611533_repasted
repaved133311133_repaved
repeated113117443_repeated
replated112817523_replated
reputed104613483_reputed
resawed113111183_resawed
reseated93220263_reseated
resited85122423_resited
reslated93517523_reslated
restated93120183_restated
rested74430783_re_sted
retaped103814283_retaped
retasted92412113_retasted
retaxed153512233_retaxed
retted74826313_re_tted
revoted114314153_revoted
rewaked153811903_rewaked
rewaxed18409343_rewaxed
rotated82715293_rotated
screaked15246983scre_aked
screamed13277603scre_amed
seated75131063_se_ated
sedated93714353_sedated
seriated92717023seriated
serrated92513433serrated
summated13298833summated
sweated113411543swe_ated
teated74924023_te_ated
tempted12317283_tempted
threated1259203thre_ated
treaded95014283tre_aded
treater74219833tre_ater
trematode1243613trematode
trembled1335253trembled
uncreated12312303uncre_ated
unmated103317023_unmated
unrelated10310433unrelated
urinated9311613urinated
wreaked15369023wre_aked
wreathed15257463wre_athed
wrested113410933wre_sted

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 Filter1786911461620.406440125.6
2DLD Change Limit1461623307.71618942.7
3Display Results3303300.1432307.7
 (SQL Overall)1786913308.26521620.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.