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

495 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
recrate9262164(None) 
recrated112918581recrated
recrates102420351recrates
recreate10313601recreate
regrate82618651regrate
acerate92818912acerate
aerate64830552ae_rate
berate84729022be_rate
cerate84829462ce_rate
crate76537402__crate
decorate11315192decorate
derate74531232de_rate
ecarte84313502_ecarte
execrate1739642execrate
ferrate103014032ferrate
pectate112214692pectate
picrate112014142picrate
rebate84424102re_bate
recane83022872rec_ane
recite83625112rec_ite
reclame11411062reclame
recoat84024272recoat_
recoated113416782recoated
recoats92616642recoats
recreated12412532recreated
recreates11313342recreates
rectorate11411352rectorate
recurvate1445852recurvate
redate74124682re_date
reflate103516262reflate
reframe1239392reframe
regrade92612032regrade
regrated102816322regrated
regrates92618372regrates
relate64033632re_late
remate84428682re_mate
replate93420052replate
reslate73520592reslate
restate73824872restate
retrace91417342retrace
rewrite10311142rewrite
rewrote1039112rewrote
secrete9311072secrete
serrate73017532serrate
uncrate9415952uncrate
accrete1137843accrete
accurate12410663accurate
acerated113113983acerated
acerbate1247533acerbate
acervate1336983acervate
acetate92514753acetate
acuate8315633_acuate
aerated85322373ae_rated
aerates74627483ae_rates
ameerate1039633ameerate
amirate91115953amirate
arcuate9311963arcuate
areolate81014453areolate
aurate64426473_aurate
baccate131011263baccate
became123213163bec_ame
becrawl1444583becrawl
becrime1387053becrime
bedmate1239433bedmate
bedrape1277693bedrape
berake124216083be_rake
berated104422133be_rated
berates94126853be_rates
borate85026153_borate
brecciate1544163brecciate
bregmate1345533bregmate
carate84734003_carate
carte75940423__carte
cate66254593__c_ate
cerated103922473ce_rated
cerates95428233ce_rates
cerebrate1348643cerebrate
cerite84724873ce_rite
cirrate92413483cirrate
citrate92216793citrate
cocreate122611813cocreate
crake114823523__crake
crane75331603__crane
crape96128443__crape
crated94827773__crated
crater85026633__crater
crates85736053__crates
crave105626313__crave
craze165221463__craze
create85126373__create
cremate113816183cre_mate
crenate93317113cre_nate
crewmate15405623crewmate
cruciate1287313cruciate
curate85226243_curate
deaerate9314163deaerate
dealate83617843dealate
debate94419193de_bate
decade104216163dec_ade
decane93818873dec_ane
decare93919153dec_are
decease1049523decease
deciare10710663deciare
decimate13411123decimate
declare10411223declare
decorated13312203decorated
decorates12314733decorates
decrease1136563decrease
decree93117783decr_ee
deflate113613943deflate
degrade10229903degrade
delate73827753de_late
dentate8315153dentate
deprave1337073deprave
depurate1139983depurate
derat65044083de_rat_
derated93623503de_rated
derates84028883de_rates
derats74625063de_rats
desecrate1249073desecrate
deviate11312713deviate
dictate10311663dictate
disrate81418523disrate
ecartes94212563_ecartes
eclat7523603_eclat_
eclats8313033_eclats
elate55335883_e_late
eluate62315433_eluate
emeerate10410093emeerate
emirate91015833emirate
enate54428143_e_nate
enrage72715073_enrage
equate152012463_equate
erase54925493_e_rase
ergate7315143_ergate
errata639013_errata
eructate1047333eructate
estate64719763_estate
eucrite939903eucrite
excrete1667163excrete
execrated1938343execrated
execrates1839543execrates
federate12310873federate
fellate10313433fellate
fermate122813003fermate
ferrates113013403ferrates
ferrite103312753ferrite
furcate12310453furcate
gelate73421253ge_late
gemmate12418383gemmate
generate9312893generate
gestate83614073gestate
grate64932883__grate
gyrate104912523_gyrate
hectare1238463hectare
hydrate14239813hydrate
increate10312203increate
ingrate8715113ingrate
irate55627983__irate
iterate71119103iterate
karate105320923_karate
lacerate102214703lacerate
lactate9312693lactate
leachate1347443leachate
legate72917453le_gate
levirate1147623levirate
librate93214233librate
locate83919843loc_ate
lyrate94112103_lyrate
macerate122314073macerate
macrame1338713macrame
mediate103415213mediate
mercurate1347333mercurate
metate82720533me_tate
migrate101314163migrate
misrate91319143misrate
narrate7313493narrate
necrose939723necrose
negate72915573ne_gate
neonate7311333neonate
nervate1039523nervate
nictate9310223nictate
nitrate72017013nitrate
obsecrate1344633obsecrate
ocreate93711743_ocreate
operate9615733operate
orate55133303__orate
outrate72323183outrate
overate10620963overate
overrate11615683overrate
pectase112410363pectase
pectates122213933pectates
peculate122414663peculate
pedate93117763pe_date
peerage1089803peerage
peltate92013773peltate
pennate93314033pennate
percale11314083percale
perorate10417913perorate
petrale9312623petrale
phorate12413363phorate
picrated132110113picrated
picrates122013203picrates
picrite111911313picrite
pirate82322883_pirate
prate75135983__prate
precrash1544823precrash
precrease1345233precrease
predate10616893pre_date
prelate9519693pre_late
prerace11414123pre_race
priorate10411733priorate
procreate1348133procreate
prorate9418733prorate
racemate1239063racemate
radiate83416313radiate
ramate83921683r_amate
rate45458763___rate
reargue836463reargue
reata54225393re__ata
reave84528023re__ave
reawake14457893reawake
rebated103619693re_bated
rebater93517903re_bater
rebates95123173re_bates
rebato83714683re_bato
recall83815723rec_all
recaned102817203rec_aned
recanes93222263rec_anes
recant83228683rec_ant
recanted112513513recanted
recanter101913153recanter
recants93217093recants
recap95718023rec_a_p
recaps103615733rec_aps
recarpet12310603recarpet
recarry1245063recarry
recast83422773rec_ast
recasts93413533recasts
recce9514563rec__ce
recede95515533rec_ede
receive1239733receive
recent83630853recent_
recenter102715443recenter
recept103319073recept_
recepts113010263recepts
rechange1458183rechange
recharge1476613recharge
rechart12314323rechart
recharted1557563recharted
recharter1466893recharter
recharts1337663recharts
recheat12415933recheat_
recheats1339193recheats
rechose121312043rechose
recipe103414893rec_ipe
recircle1244433recircle
recit75235103rec_it_
recital9412163recital
recited104319103rec_ited
reciter94117263rec_iter
recites93524583rec_ites
recits83621353rec_its
reclad9311873recla_d
reclads1049993reclads
reclaim1137753reclaim
reclames12310893reclames
reclasp1136643reclasp
reclinate11410023reclinate
recline94020493recline
reclothe1345733reclothe
recluse95210773recluse
recoal84117973recoa_l
recoaled113111783recoaled
recoals94214623recoals
recode93618713rec_ode
recoupe11109933recoupe
recrating121318783recrating
recreance1346983recreance
recreant10311283recreant
recreants1146623recreants
recreative1549023recreative
recross989833recross
recrown12257573recrown
recruit939773recruit
recruited1236453recruited
recruiter1144873recruiter
recruits1036563recruits
recta74220263rec__ta
rectal84418133recta_l
recti73619623rec__ti
recto74520803rec__to
rectorates12410343rectorates
recuperate1445933recuperate
recurve1237403recurve
recuse85519163rec_use
recut74729243rec_ut_
recuts83817373rec_uts
recycle1445343recycle
redated93120923re_dated
redates83423863re_dates
redcoat10410883redcoat_
redcoats1147123redcoats
redecorate1346133redecorate
rediae74221993redia_e
redictate1249063redictate
redraft11310573redraft
redrafted1435143redrafted
redrafts1235603redrafts
redraw10269853redra_w
redrawer1235313redrawer
redrawn11245953redrawn
redraws11218473redraws
redrive112410563redrive
redrove11249423redrove
redware1139353redware
reface113616353re_face
reflated123514293reflated
reflates113115653reflates
reformate1446953reformate
refract121311603refract
refracted1557393refracted
refracts13137383refracts
refrain10310043refrain
reframed1437853reframed
reframes1338983reframes
refroze1956223refroze
refute95515703re_fute
regale74821453re_gale
regave104713383re_gave
regelate9312083regelate
reggae858953regga_e
reglaze1747223reglaze
regmata1036193regmata
regraded113410763regraded
regrades103212163regrades
regraft11310153regraft
regrafted1435243regrafted
regrafts1235303regrafts
regrant8317323regrant
regranted1137703regranted
regrants9310013regrants
regreet83015953regreet
regret73723533regret_
regrets83212923regrets
regulate9313023regulate
reheat94423943reheat_
reheated122415003reheated
reheater113413033reheater
reheats104513523reheats
rehydrate1644793rehydrate
reimage1037913reimage
reiterate9412923reiterate
relace83122153re_lace
related83327573re_lated
relater73723143re_later
relates73731423re_lates
release7312763release
relegate9311243relegate
relocate10713533relocate
reluctate1146913reluctate
remade94316983re_made
remake124016113re_make
remated103522473re_mated
remates93827103re_mates
remigrate1249223remigrate
remote84222603re_mote
rename82718813re_name
rennase738713rennase
renovate1138553renovate
rente54733783re__nte
reoperate11410173reoperate
repartee10312753repartee
repave114813873re_pave
repeat85127213repeat_
repeated113117443repeated
repeater102615443repeater
repeats94316053repeats
rephrase1346733rephrase
replace113214283replace
replated112817513replated
replates102919263replates
replete92912983replete
reprice113212833reprice
reprise92715043reprise
reprobate1347683reprobate
reprobe112310133reprobe
reprove122911073reprove
repute84716093re_pute
requite162012483requite
rerack122513163re_rack
reraise7316313re_raise
reran57329103re_ra_n
rerise64325633re_rise
rerose63320843re_rose
reroute7313963reroute
resale64025543re_sale
resat55139683re_sat_
rescale93215473rescale
reseat64131493reseat_
reseated93220263reseated
reseats74319583reseats
reshape1249043reshape
reshave1338603reshave
resinate8316773resinate
resite64128453re_site
reslated93517523reslated
reslates83619493reslates
resonate8513513resonate
respace11310913respace
respade1039573respade
respite9513033respite
restage83316183restage
restated93120173restated
restates83423413restates
retake104718533re_take
retape83917683re_tape
retardate1047023retardate
retaste72313133retaste
rete44944133re___te
retraced111413023retraced
retracer101411883retracer
retraces101417263retraces
retrack131310723retrack
retract91318113retract
retracted12410953retracted
retracts101111313retracts
retrain7615423retrain
retral64419743retra_l
retreat7317533retreat_
retreated10312613retreated
retreater9310193retreater
retreats8311403retreats
reunite7312713reunite
revibrate1446373revibrate
revote94917453re_vote
rewake135218463re_wake
reweave1336773reweave
rewrap11127533rewra_p
rewraps12136563rewraps
rewrapt12138113rewrapt
rewriter1137923rewriter
rewrites11311053rewrites
ricrac1037013ricra_c
ricracs1136363ricracs
roseate7613453roseate
rostrate8313833rostrate
rotate63320343r_otate
rugate75813813r_ugate
ruinate7312833ruinate
saccate111311763saccate
scrape105917573_scrape
secret8325063secret_
secreted1138633secreted
secreter1038503secreter
secretes10410473secretes
secrets9311773secrets
sedate73019803se_date
senate63725143se_nate
sensate7311883sensate
separate10310783separate
septate9511873septate
serape84818413se_rape
seriate73722473seriate
serrated92513423serrated
serrates82617003serrates
speciate12209583speciate
spectate12248833spectate
stearate839713stearate
sucrase9310343sucrase
tectite9310583tectite
terete6319333te_rete
ternate7415483ternate
terrace93311833terrace
terrae62915203terra_e
terrane72814223terrane
testate73916233testate
thecate123210023thec_ate
titrate72215573titrate
toccate1138773toccate
tractate10411003tractate
ulcerate1039733ulcerate
uncrated11416313uncrated
uncrates10314553uncrates
uncreate10311353uncreate
uprate83916543_uprate
urate55432163__urate
vacate11314553vac_ate
velate93720143ve_late
venerate11312893venerate
verite94323443ve_rite
verste94515633ve_rste
vibrate122811513vibrate
vicarate1378603vicarate
wreckage1842763wreckage

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.1561145455.1
2DLD Change Limit1340274955.92022639.7
3Display Results4954950.1732861.3
 (SQL Overall)1786914956.24928595.1
 
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.