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

445 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
recrates10242037(None) 
recrate92621661recrate_
recrated112918601recrated
recreates11313361recreates
regrates92618401regrates
aerates74627492ae_rates
berates94126872be_rates
cerates95428252ce_rates
crates85736062__crates
decorates12314742decorates
derates84028892de_rates
ecartes94212562_ecartes
execrates1839562execrates
ferrates113013422ferrates
pectates122213952pectates
picrates122013212picrates
rebates95123182re_bates
recanes93222262rec_anes
recites93524582rec_ites
reclames12310892reclames
recoated113416782recoated
recoats92616642recoat_s
recreate10313602recreate_
recreated12412532recreated
rectorates12410362rectorates
redates83423872re_dates
reflates113115662reflates
reframes1338992reframes
regrades103212172regrades
regrate82618662regrate_
regrated102816332regrated
relates73731432re_lates
remates93827112re_mates
replates102919272replates
reslates83619502reslates
restates83423432restates
retraces101417272retraces
rewrites11311062rewrites
secretes10410472secretes
serrates82617022serrates
uncrates10314562uncrates
accretes1238113accretes
acerate92818913acerate_
acerated113113983acerated
acerbates1347263acerbates
acetates102013063acetates
aerate64830553ae_rate_
aerated85322373ae_rated
ameerates1149063ameerates
amirates101114793amirates
becrawls1543623becrawls
becrimes1467073becrimes
bedmates1349183bedmates
bedrapes1386963bedrapes
berakes134815773be_rakes
berate84729023be_rate_
berated104422133be_rated
borates94823013_borates
brecciates1644263brecciates
carates95630613_carates
cartes86239473__cartes
cates75951893__c_ates
cerastes101111093ce_rastes
cerate84829463ce_rate_
cerated103922473ce_rated
cerebrates1447913cerebrates
cerites94823433ce_rites
certes84623083ce_r_tes
citrates102315093citrates
cocreates132611883cocreates
crakes124921813__crakes
cranes84330753__cranes
crapes104727693__crapes
crases85532313__crases
crate76537403__crate_
crated94827773__crated
crater85026643__crater
craters95021893__craters
craves115825393__craves
crazes174720133__crazes
creates95225203__creates
cremates124216003cre_mates
crewmates16375803crewmates
curates95323833_curates
deaerates10313643deaerates
dealates92716683dealates
debates103718533de_bates
decades113615513dec_ades
decanes103118913dec_anes
decares102818533dec_ares
deceases11410153deceases
deciares11510633deciares
decimates14410693decimates
declares11611313declares
decorate11315193decorate_
decorated13312203decorated
decreases1237223decreases
decrees102513123decr_ees
decries103319803decr_ies
deflates123013943deflates
degrades11269923degrades
delates83526283de_lates
depraves1436873depraves
depurates1239823depurates
derate74531233de_rate_
derated93623503de_rated
derats74625063de_rat_s
desecrates1348843desecrates
deviates12312733deviates
dictates11311383dictates
disrates91118153disrates
ecarte84313503_ecarte_
eclats8313033_eclat_s
ectases92911673_ectases
elates65032363_e_lates
eluates72014683_eluates
emeerates1149373emeerates
emirates101214853emirates
enates64026423_e_nates
enrages83114853_enrages
equates162012323_equates
erases64425403_e_rases
ergates8314493_ergates
erratas736863_erratas
eructates1146953eructates
estates74520183_estates
eucrites1049483eucrites
excretes1787573excretes
execrate1739653execrate_
execrated1938353execrated
federates13310153federates
fellates11312753fellates
ferrate103014043ferrate_
ferrites112312833ferrites
furcates1339883furcates
gelates83219583ge_lates
gemmates13307673gemmates
generates10312713generates
gestates93213733gestates
grates75429893__grates
gyrates113610263_gyrates
hectares1338853hectares
hydrates15229413hydrates
ingrates9514173ingrates
iterates81317823iterates
karates115617473_karates
lacerates112413773lacerates
lactates10311223lactates
leachates1446663leachates
legates82917683le_gates
levirates1247493levirates
librates103412953librates
locates93218813loc_ates
macerates132113573macerates
macrames1438953macrames
mediates112814063mediates
mercurates1446853mercurates
metates92720013me_tates
migrates111112853migrates
misrates101318243misrates
narrates8312763narrates
necroses10310563necroses
negates83215843ne_gates
neonates8310063neonates
nictates1039593nictates
nitrates82516223nitrates
obsecrates1444583obsecrates
operates10515413operates
orates64328613__orates
outrates82421373outrates
overrates12414623overrates
pectases122411193pectases
pectate112214693pectate_
peculates132112543peculates
peerages1189893peerages
penates93321593pe_nates
percales12313803percales
perorates11417023perorates
petrales10312983petrales
phorates13413043phorates
picrate112014143picrate_
picrated132110113picrated
picrites121811083picrites
pirates93020333_pirates
prates84633163__prates
precreases1445653precreases
predates11615813pre_dates
prelates10418573pre_lates
priorates11410763priorates
procreates1448153procreates
prorates10418073prorates
racemates1348853racemates
radiates92415293radiates
rates55352013___rates
reales64934123re__ales
reargues936713reargues
reatas64021013re__atas
reaves94127573re__aves
reawakes15348073reawakes
rebate84424113re_bate_
rebated103619703re_bated
rebater93517913re_bater
rebaters103413943re_baters
rebatos92913113re_batos
recalls92613623rec_alls
recane83022873rec_ane_
recaned102817203rec_aned
recanted112513513recanted
recanter101913153recanter
recanters112310483recanters
recants93217093rec_ants
recaps103615733rec_a_ps
recarpet12310603recarpet
recarpets1344383recarpets
recarries1147863recarries
recasts93413533rec_asts
recces10614913rec__ces
recedes102816063rec_edes
receives1339743receives
recenter102715443recenter
recentest11410283recentest
recepts113010263recept_s
recesses10312323recesses
rechanges1568183rechanges
recharges1586953recharges
recharted1557563recharted
recharter1466893recharter
recharters1555423recharters
recharts1337663recharts
recheats1339193recheat_s
recipes113314463rec_ipes
recircles1344433recircles
recitals1039763recitals
recite83625113rec_ite_
recited104319103rec_ited
reciter94117263rec_iter
reciters102613113rec_iters
recits83621353rec_it_s
reclads1049993recla_ds
reclaims1236113reclaims
reclame11411063reclame_
reclasps1235053reclasps
reclines103718543reclines
reclothes1445643reclothes
recluses105111733recluses
recoaled113111783recoaled
recoals94214623recoa_ls
recoat84024273recoat__
recodes102918633rec_odes
recopies12313733recopies
recrating121318793recrating
recreances1446503recreances
recreants1146623recreants
recross989833recr_oss
recrosses1138373recrosses
recrowns13246143recrowns
recruited1236453recruited
recruiter1144873recruiter
recruiters1243713recruiters
recruits1036563recruits
rectorate11411363rectorate_
rectos85718783rec__tos
rectrices1338873rectrices
rectus83314633rec__tus
recuperates1545603recuperates
recurvate1445853recurvate_
recurves1337403recurves
recuses94619463rec_uses
recuts83817373rec_ut_s
recycles1535353recycles
redate74124683re_date_
redated93120923re_dated
redcoats1147123redcoat_s
redecorates1465683redecorates
redictates1348233redictates
redrafted1435143redrafted
redrafts1235603redrafts
redrawer1235313redrawer
redrawers1344353redrawers
redraws11218473redra_ws
redries83721713redr_ies
redrives122610393redrives
redwares1239053redwares
refaces123216743re_faces
reflate103516263reflate_
reflated123514293reflated
reformates1546263reformates
refracted1557393refracted
refracts13137383refracts
refrains1139593refrains
reframe1239393reframe_
reframed1437853reframed
refries104419733refr_ies
refutes104515723re_futes
regales83520793re_gales
regelates10311113regelates
reggaes948883regga_es
reglazes1846793reglazes
regrade92612033regrade_
regraded113410763regraded
regrafted1435243regrafted
regrafts1235303regrafts
regranted1137703regranted
regrants9310013regrants
regreets9287853regreets
regrets83212923regret_s
regulates101211723regulates
reheated122415003reheated
reheater113413033reheater
reheaters122010273reheaters
reheats104513523reheat_s
rehydrates1744463rehydrates
reimages1138373reimages
reiterates10412003reiterates
relaces93420883re_laces
relate64033633re_late_
related83327573re_lated
relater73723143re_later
relaters83218153re_laters
relaxes143215323re_laxes
releases8313343releases
relegates10310943relegates
relocates11712933relocates
reluctates1246703reluctates
remakes134116173re_makes
remate84428683re_mate_
remated103522473re_mated
remigrates1348583remigrates
remotes94521613re_motes
renames92418053re_names
rennases848983rennases
renovates1248453renovates
rentes65431193re__ntes
reoperates1249663reoperates
repartee10312753repartee
repartees1147253repartees
repaves123513653re_paves
repeated113117443repeated
repeater102615443repeater
repeaters112811993repeaters
repeats94316053repeat_s
rephrases1447413rephrases
replaces123114123replaces
replate93420053replate_
replated112817523replated
repletes102812473repletes
reprices122913353reprices
reprises102615463reprises
reprobates1447363reprobates
reprobes121910293reprobes
reproves132011473reproves
reputes94615963re_putes
requites171511763requites
reracks132310533re_racks
reraise7316313re_raise
reraises8415643re_raises
rerises73525883re_rises
reroutes8312223reroutes
resales74724903re_sales
rescales103414573rescales
reseated93220263reseated
reseats74319583reseat_s
reshapes1338803reshapes
reshaves1438733reshaves
resinates9314763resinates
resites74027793re_sites
reslate73520593reslate_
reslated93517523reslated
resonates9412403resonates
respaces12311043respaces
respades1139853respades
respites10513243respites
restages92815773restages
restate73824883restate_
restated93120183restated
retakes113718863re_takes
retapes93917423re_tapes
retardates1146433retardates
retastes82212903retastes
retaxes143615093re_taxes
retrace91417343retrace_
retraced111413023retraced
retracer101411883retracer
retracers11149553retracers
retracks14149103retracks
retracted12410953retracted
retracts101111313retracts
retrains8314533retrains
retreated10312623retreated
retreater9310203retreater
retreaters1047543retreaters
retreats8311413retreat_s
retries74129073retr_ies
reunites8312473reunites
revibrates1546273revibrates
revotes104716393re_votes
rewakes144614983re_wakes
rewaxes173911333re_waxes
reweaves1436603reweaves
rewraps12136563rewra_ps
rewrite10311143rewrite_
rewriter1137923rewriter
rewriters1236343rewriters
rewrote1039113rewrote_
ricracs1136363ricra_cs
rotates72819773r_otates
ruinates8311883ruinates
scrapes116217663_scrapes
secrete9311073secrete_
secreted1138633secreted
secreter1038503secreter
secretest1147033secretest
secrets9311773secret_s
sedates83418033se_dates
senates73322583se_nates
sensates8511133sensates
separates11310743separates
serapes95218103se_rapes
seriates82620673seriates
serrate73017543serrate_
serrated92513433serrated
speciates13229233speciates
spectates13228813spectates
stearates939453stearates
sucrases10310253sucrases
tectites1039993tectites
terraces102712253terraces
terranes82514433terranes
terrases82111483terrases
testates83615453testates
titrates82314663titrates
tractates1159763tractates
ulcerates1148853ulcerates
uncrate9415953uncrate_
uncrated11416313uncrated
uncreates11310433uncreates
uprates93814863_uprates
urates65027763__urates
vacates12312833vac_ates
venerates12312263venerates
verites103822263ve_rites
verstes104014283ve_rstes
vibrates132210613vibrates
vicarates1487623vicarates
wreckages1942773wreckages

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 Filter1786911461620.406440125.6
2DLD Change Limit1461624457.26620115.9
3Display Results4454450.1862392.5
 (SQL Overall)1786914457.85822740.0
 
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.