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

199 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
recreate1031360(None) 
recrate92621661recr_ate
recreated12412531recreated
recreates11313361recreates
cocreate122611812cocreate
create85126382__create
decrease1136562decrease
increate10312202increate
ocreate93711742_ocreate
precrease1345232precrease
procreate1348142procreate
recheat12415932recheat_
recheats1339192recheats
recrated112918602recr_ated
recrates102420372recr_ates
recreance1346992recreance
recreant10311282recreant
recreants1146622recreants
recreative1549022recreative
recurvate1445852recurvate
regrate82618662regr_ate
retreat7317532retreat_
retreated10312622retreated
retreater9310202retreater
retreats8311412retreats
secrete9311072secre_te
uncreate10311352uncreate
accrete1137843accre_te
acerate92818913acer_ate
acerbate1247533acerbate
acervate1336983acervate
acreage1037843_acreage
aerate64830553ae_r_ate
aureate72515283_aureate
berate84729023be_r_ate
bereave1258353be_reave
bracteate1345353bracteate
brecciate1544173brecciate
cerate84829463ce_r_ate
cocreated142710093cocreated
cocreates132611883cocreates
crate76537403__cr_ate
crease85519573__crease
created104323453__created
creates95225203__creates
cremate113816183__cremate
crenate93317113__crenate
deaerate9314173deaerate
decease1049523dec_ease
decimate13411123decimate
decorate11315193decorate
decreased1345453decreased
decreases1237223decreases
decree93117783decre__e
decretal1146353decretal
degrease1045413degrease
deprecate1477433deprecate
depredate1345733depredate
derate74531233de_r_ate
ergate7315143_e_rgate
excrete1667163excre_te
execrate1739653execr_ate
federate12310883federate
fermate122813003fe_rmate
ferrate103014043fe_rrate
generate9312903generate
hereat93527413he_reat_
increase1066453increase
lacerate102214703lacerate
laureate888023laureate
macerate122314073macerate
miscreate1348893miscreate
nervate1039533ne_rvate
nucleate1048673nucleate
ocreae83310273_ocrea_e
pectate112214693pec_tate
peculate122414673peculate
permeate12311613permeate
picrate112014143picr_ate
precreased1544413precreased
precreases1445653precreases
pretreat10311923pretreat_
pretreated1347623pretreated
pretreats1146933pretreats
procreated1546443procreated
procreates1448153procreates
racemate1239063racemate
raclette1047643raclette
rebate84424113re__bate
recane83022873rec__ane
recede95515533rec_e_de
receive1239733rec_eive
recent83630853rec_ent_
recenter102715443rec_enter
recept103319073rec_ept_
recepts113010263rec_epts
recite83625113rec__ite
reclame11411063rec_lame
reclean938523reclea_n
recleaned1236583recleaned
recleans1037513recleans
reclinate11410023reclinate
recoat84024273rec_oat_
recoated113416783rec_oated
recoats92616643rec_oats
recreances1446503recreances
recreancy1643783recreancy
recreating131214583recreating
recreation12413613recreation
recruit939773recruit_
recruited1236453recruited
recruiter1144873recruiter
recruits1036563recruits
rectorate11411363rectorate
recuperate1445933recuperate
redate74124683re__date
redream10107913redrea_m
redreamed1345023redreamed
redreams1195953redreams
redreamt11127183redreamt
reelevate1245663reelevate
reerect92915883reerect_
reerected1238613reerected
reerects10319923reerects
reflate103516263re_flate
reformate1446953reformate
reframe1239393refr_ame
refreeze2063263refreeze
regelate9312083regelate
regrade92612033regr_ade
regrated102816333regr_ated
regrates92618403regr_ates
regreet83015953regreet_
regreeted1136173regreeted
regreets9287853regreets
regret73723533regre_t_
regrets83212923regre_ts
regretted1137233regretted
regretter1045973regretter
regulate9313023regulate
reheat94423943re_heat_
reheated122415003re_heated
reheater113413033re_heater
reheats104513523re_heats
reiterate9412933reiterate
relate64033633re__late
release7312763re_lease
relegate9311243relegate
relocate10713533relocate
remate84428683re__mate
renovate1138553renovate
reoperate11410183reoperate
repeat85127213re_peat_
repeated113117443re_peated
repeater102615443re_peater
repeats94316053re_peats
replate93420053re_plate
replete92912993reple_te
reprobate1347683reprobate
reread71715433re_rea_d
rereads81512293re_reads
rerent63832453re_rent_
rerented92516163re_rented
rerents73319423re_rents
reroute7313963re_route
reseat64131493re_seat_
reseated93220263re_seated
reseats74319583re_seats
resinate8316773resinate
reslate73520593re_slate
resonate8513513resonate
restate73824883re_state
retardate1047023retardate
retrace91417343retr_ace
retread849003retrea_d
retreaded1137053retreaded
retreads937823retreads
retreaters1047543retreaters
reweave1336773re_weave
rewrite10311143rewr_ite
rewrote1039123rewr_ote
roseate7613453r_oseate
secret8325063secre_t_
secreted1138633secre_ted
secreter1038513secre_ter
secretes10410473secre_tes
secrets9311773secre_ts
segregate1145073segregate
serenate81914883se_renate
seriate73722473se_riate
serrate73017543se_rrate
terete6319333te_re_te
ternate7415483te_rnate
tracheate1448233tracheate
ulcerate1039733ulcerate
uncrate9415953uncr_ate
uncreated12312303uncreated
uncreates11310433uncreates
venerate11312903venerate

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.436409841.7
2DLD Change Limit1461621997.15620425.1
3Display Results1991990.0932139.8
 (SQL Overall)1786911997.68523251.9
 
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.