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

239 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
reframe123939(None) 
reframed1437851reframed
reframes1338981reframes
bedframe1643022bedframe
defame123212432def_ame
enframe1247362enframe
frame105821802__frame
preflame1545912preflame
reclame11411062reclame
recrate92621642recrate
reface113616352ref_ace
reflate103516262reflate
refract121311602refract
refrain10310042refrain
refroze1956222refroze
regrade92612032regrade
regrate82618652regrate
rename82718812re_name
retrace91417342retrace
aerate64830553ae_rate
aflame1138723_aflame
airframe1344293airframe
arame75026623__arame
became123213163be_came
becrime1387053becrime
bedframes1743013bedframes
bedrape1277693bedrape
begrime1276553begrime
beldame1237233beldame
bename103316073be_name
berake124216083be_rake
berate84729023be_rate
berime105317333be_rime
berme96022943be_r_me
beshame1447483beshame
cerate84829463ce_rate
deface123113863def_ace
defamed14309833def_amed
defamer132710323def_amer
defames132812253def_ames
deflate113613943deflate
defoam1238563defoam_
defoamed15356243defoamed
defoamer14276213defoamer
defoams1336193defoams
defrag1136463defra_g
defrags1236193defrags
defraud1243913defraud
defray1337643defra_y
defrayed1635403defrayed
defrayer1534933defrayer
defrays1436113defrays
degame102713183de_game
degrade10229903degrade
deprave1337073deprave
derate74531233de_rate
efface14366673_efface
enflame1236573enflame
enframed1466263enframed
enframes1357453enframes
enrage72715073_enrage
erase54925493_e_rase
fame95639393__f_ame
ferrate103014033ferrate
flame105124443__flame
frae75330473__fra_e
framed125116523__framed
framer114817443__framer
frames115119863__frames
hermae115314473he_rmae
inflame1256963inflame
macrame1338713macrame
misframe1546973misframe
offramp1742153offramp
peerage1089803peerage
penname11328553penname
perfume1446503perfume
petrale9312623petrale
preface14510923pref_ace
prefade1339013pref_ade
prefrank1764233prefrank
prefroze2264673prefroze
pregame1239553pre_game
prename11412643pre_name
prerace11414123pre_race
ream65841613re__am_
reamed94326123re__amed
reamer84325213re__amer
reams75729623re__ams
reargue836463reargue
rearm75923563rear_m_
rearmed103912823rear_med
rearms85114653rear_ms
reave84528023re__ave
reawake14457893reawake
rebate84424103re_bate
recane83022873re_cane
reclames12310893reclames
recrated112918583recrated
recrates102420353recrates
recreate10313603recreate
redate74124683re_date
rediae74221993redia_e
redraft11310573redraft
redraw10269853redra_w
redrawer1235313redrawer
redrawn11245953redrawn
redraws11218473redraws
redream10107913redream_
redreamed1345023redreamed
redreams1195953redreams
redreamt11127183redreamt
redrive112410563redrive
redrove11249423redrove
redware1139353redware
refaced133713573ref_aced
refaces123216743ref_aces
refall94314393ref_all
refence12312223refence
referable1439623referable
referee101615753referee
refile95122373ref_ile
refilm114311403refilm_
refilmed14235813refilmed
refilms12347503refilms
refine95225693ref_ine
refire95419473ref_ire
reflag1098083refla_g
reflags1156953reflags
reflated123514293reflated
reflates113115653reflates
reforge11259033reforge
reform11312703reform_
reformat1357653reformat
reformate1446953reformate
reformed14249603reformed
reformer13217953reformer
reforms1239813reforms
refracted1557393refracted
refracts13137383refracts
refrained1347223refrained
refrainer1245843refrainer
refrains1139583refrains
reframing1538613reframing
refreeze2063263refreeze
refresh1335453refresh
refried113513873refried
refries104419733refries
refront10313263refront
refrozen2063873refrozen
refry114412463refr__y
refuge105312613ref_uge
refugee115310943refugee
refuse94817513ref_use
refute95515703ref_ute
regale74821453re_gale
regave104713383re_gave
reggae858953regga_e
regime95313943re_gime
reglaze1747223reglaze
regraded113410763regraded
regrades103212163regrades
regraft11310153regraft
regrant8317323regrant
regrated102816323regrated
regrates92618373regrates
reimage1037913reimage
reinflame14133883reinflame
relace83122153re_lace
relate64033633re_late
release7312763release
relume8313273re_lume
remade94316983re_made
remake124016113re_make
remate84428683re_mate
renamed103114523re_named
renames92418053re_names
rennase738713rennase
repave114813873re_pave
rephrase1346733rephrase
replace113214283replace
replate93420053replate
reprice113212833reprice
reprise92715043reprise
reprobe112310133reprobe
reprove122911073reprove
rerack122513163re_rack
reraise7316313re_raise
reran57329103re_ra_n
rerise64325633re_rise
rerose63320843re_rose
resale64025543re_sale
rescale93215473rescale
reshape1249043reshape
reshave1338603reshave
reslate73520593reslate
respace11310913respace
respade1039573respade
restage83316183restage
restamp1146483restamp
restate73824873restate
resume8313783re_sume
retake104718533re_take
retape83917683re_tape
reteam83214533reteam_
reteamed1138013reteamed
reteams9339563reteams
retime85321803re_time
retraced111413023retraced
retracer101411883retracer
retraces101417263retraces
retrack131310723retrack
retract91318113retract
retrain7615423retrain
retral64419743retra_l
retrim83514873retrim_
retrims93612373retrims
revamp1336013re_vamp
rewake135218463re_wake
rewarm115913483rewarm_
rewarmed14257433rewarmed
rewarms12439593rewarms
reweave1336773reweave
rewrap11127533rewra_p
rewraps12136563rewraps
rewrapt12138113rewrapt
rewrite10311143rewrite
rewrote1039113rewrote
selfsame1342883selfsame
serape84818413se_rape
serfage1138403serfage
serrate73017533serrate
sesame8311013se_same
subframe1546333subframe
terrace93311833terrace
terrae62915203terra_e
terrane72814223terrane
tetramer1046813tetramer
unframed1478243unframed

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272398.61015566.4
3Display Results2392390.1401707.1
 (SQL Overall)1786912398.90620064.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.