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

233 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
recreated1241254(None) 
recrated112918611recr_ated
recreate10313601recreate_
recreates11313361recreates
retreated10312631retreated
cocreated142710092cocreated
created104323462__created
decreased1345462decreased
precreased1544422precreased
pretreated1347632pretreated
procreated1546442procreated
recleaned1236582recleaned
recoated113416792rec_oated
recrate92621662recr_ate_
recrates102420372recr_ates
recruited1236462recruited
redreamed1345022redreamed
reerected1238612reerected
regrated102816332regr_ated
regreeted1136172regreeted
regretted1137232regretted
reheated122415002re_heated
repeated113117442re_peated
rerented92516162re_rented
reseated93220262re_seated
retreaded1137062retreaded
retreater9310202retreater
secreted1138642secre_ted
uncreated12312302uncreated
accreted1336353accre_ted
acerated113114003acer_ated
acerbated1465563acerbated
aerated85322383ae_r_ated
becrusted1443953becrusted
befretted1544373befretted
berated104422133be_r_ated
bereaved1446403be_reaved
brecciated1743523brecciated
cerated103922473ce_r_ated
cheated134416353__cheated
cleated103417853__cleated
cocreate122611813cocreate_
cocreates132611883cocreates
crated94827773__cr_ated
creaked143413233__creaked
creamed123913713__creamed
creased104315593__creased
create85126383__create_
creates95225203__creates
cremated133412963__cremated
crenated113013913__crenated
crested103416553__crested
deaerated11311123deaerated
deceased1247723dec_eased
decimated1548953decimated
decorated13312213decorated
decrease1136573decrease_
decreases1237233decreases
decreed112710263decre__ed
decrypted1842773decrypted
defeated132812163de_feated
degreased1244723degreased
deprecated1646673deprecated
depredated1544813depredated
derated93623503de_r_ated
entreated10310973entreated
erected103213993_e_rected
escheated1546273escheated
estreated1039563estreated
excreted1846153excre_ted
execrated1938353execr_ated
federated1438423federated
ferreted1236333ferre_ted
floreated1346573floreated
generated11310203generated
increased1245543increased
increate10312203increate_
intreated10312663intreated
lacerated122210693lacerated
laureated1096163laureated
macerated142010533macerated
miscreated1547423miscreated
nucleated1247873nucleated
ocreate93711743_ocreate_
peculated142310853peculated
permeated1439373permeated
picrated132110113picr_ated
precented14310693prec_ented
precleaned1543803precleaned
precleared1544123precleared
precrease1345233precrease_
precreases1445653precreases
preerected1545573preerected
preheated1539813pre_heated
procreate1348143procreate_
procreates1448153procreates
racheted14149513rache_ted
racketed15169133racke_ted
reaccented1544903reaccented
reaccepted1743343reaccepted
rearrested1145143rearrested
rebated103619703re__bated
rebreed104611073rebre__ed
recaned102817203rec__aned
recanted112513513rec_anted
recarpeted1543713recarpeted
receded112713043rec_e_ded
receipted1445353receipted
received1437983rec_eived
recemented1546163recemented
recenter102715443rec_enter
recessed1139723rec_essed
recharted1557563recharted
recheat12415933recheat__
recheats1339193recheat_s
rechecked2143973rechecked
rechewed1735633reche_wed
recited104319103rec__ited
recoaled113111793rec_oaled
recounted1238723recounted
recreance1346993recreance
recreances1446503recreances
recreancy1643783recreancy
recreant10311283recrea_nt
recreants1146623recreants
recreating131214583recreating
recreation12413613recreation
recreative1549023recreative
recrossed1246523recrossed
recrowned1564863recrowned
recruiter1144873recruiter
recuperated1645173recuperated
recurvate1445853recurvate_
redated93120923re__dated
redefeated1544883redefeated
redheaded1545083redheaded
redirected1444773redirected
redrafted1435143redrafted
redressed1137783redressed
reejected1955093reejected
reelected1238313reelected
reelevated1445153reelevated
reested82916233re__ested
refected142311663re_fected
reflated123514293re_flated
reflected1547983reflected
refloated1347013refloated
reforested1445393reforested
refracted1557393refracted
reframed1437853refr_amed
refreshed1685623refreshed
refronted1336063refronted
regeared1039433re_geared
regelated1139723regelated
regraded113410763regr_aded
regrafted1435243regrafted
regranted1137703regranted
regrate82618663regr_ate_
regrates92618403regr_ates
regreened1145553regreened
regressed1138123regressed
regretter1045973regretter
regulated11310463regulated
reheater113413033re_heater
reiterated11410163reiterated
rejected182710113re_jected
related83327573re__lated
released9310243re_leased
relegated1139763relegated
relented92614943re_lented
relocated12710813relocated
remated103522473re__mated
remelted11310153re_melted
renested92212953re_nested
renovated1347173renovated
reoperated1348153reoperated
reoriented1145343reoriented
repealed113211873re_pealed
repeater102615443re_peater
repented112614983re_pented
replated112817523re_plated
repleaded1336293repleaded
repressed12610113repressed
reprinted1289043reprinted
reprobated1546393reprobated
requested1935893requested
reread71715433re_rea__d
rerepeated1346193rerepeated
rerouted9311153re_routed
rescreened1344123rescreened
resealed92713973re_sealed
resected112514743re_sected
resented92716963re_sented
resinated10413283resinated
reslated93517523re_slated
resmelted1236043resmelted
resonated10510613resonated
respected1438493respected
restated93120183re_stated
reteamed1138013re_teamed
retested92212533re_tested
rethreaded1543273rethreaded
retraced111413033retr_aced
retracted12410953retracted
retread849003retrea__d
retreat7317533retreat__
retreaters1047553retreaters
retreats8311413retreat_s
retroacted1366143retroacted
revealed123211213re_vealed
reverted122714713re_verted
revested122612243re_vested
revetted122210943re_vetted
reweaved1535953re_weaved
rewetted12228353re_wetted
rocketed15157793rocke_ted
screaked15246983_screaked
screamed13277603_screamed
secrete9311073secre_te_
secreter1038513secre_ter
secretes10410473secre_tes
segregated1344523segregated
seriated92717023se_riated
serrated92513433se_rrated
threated1259203_threated
tracheated1646333tracheated
treated83618703__treated
ulcerated1247753ulcerated
uncrated11416313uncr_ated
uncreate10311353uncreate_
uncreates11310433uncreates
untreated10312913untreated
venerated1339953venerated

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 Filter1786911486410.453394461.4
2DLD Change Limit1486412337.36020195.8
3Display Results2332330.1102118.2
 (SQL Overall)1786912337.92322553.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.