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

161 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
refight148887(None) 
prefight1746391prefight
refights1555881refights
relight11512061relight
resight11510641resight
bedight1437482bedight
delight12610672delight
eight94928052_e_ight
fight124027092__fight
firefight1944132firefight
freight1447602fre_ight
height134713432he_ight
infight1437452infight
preflight1844672preflight
refit84230062refi__t
refought1564232refought
relights1248052relights
resights1246732resights
right94430502r__ight
weight133914182we_ight
affright1844193affright
alight103816863_alight
alright1148853alright
aright103817663_aright
bedights1544743bedights
befit105222663befi__t
beknight1843563beknight
bight118728843__bight
blight124114623_blight
bright124215923_bright
catfight1744273catfight
defiant11311923defiant
deficit1339673deficit
delights1347333delights
dight104027003__dight
dogfight1742993dogfight
dreigh11246443dre_igh_
eighth133310603_e_ighth
eights103618983_e_ights
eighty133711603_e_ighty
eyesight1543513eyesight
fights133816553__fights
firefights2043313firefights
firelight1655533firelight
flight134014813_flight
foresight1645323foresight
freights1555853fre_ights
fright133715243_fright
gunfight1643493gunfight
heigh124812543he_igh_
heighth13366343he_ighth
heights14399443he_ights
hight125327233__hight
infights1545573infights
inflight1545893inflight
insight1137913insight
knight1438173_knight
light94429603__light
might113827083__might
neigh94912383ne_igh_
neighs10387733ne_ighs
night94327853__night
outfight1546103outfight
penlight1446423penlight
plight123513363_plight
preflights1943323preflights
prizefight2851513prizefight
rebirth1244933rebirth
rebought1474393rebought
recit75235103reci__t
redfish1437793redfish_
redigest1039733redigest
redipt94116743redi_pt
reefiest112811483reefiest
refect114319333ref_ect
refelt94521423ref_elt
refighting1845203refighting
refigure1254693refigure
refile95122373refi_le
refiled114318653refiled
refiles104122423refiles
refill94514053refi_ll
refills103711423refills
refilm114311403refi_lm
refilms12347503refilms
refind104717073refi_nd
refinds114512123refinds
refine95225693refi_ne
refined114720003refined
refiner105316913refiner
refines105426343refines
refire95419473refi_re
refired115116993refired
refires104820313refires
refits94017653refi_ts
refix155212483refi__x
refixed183611153refixed
refixes174813173refixes
reflect123913713reflect
reflet94024233ref_let
refloat10310833refloat
refract121311603refract
refront10313263refront
reft75141273ref___t
refuge105312613refug_e
refuged125410873refuged
refugee115310943refugee
refuges115413373refuges
refugia1144313refugia
regilt71217493regi_lt
reign65015193re_ig_n
reigns74811753re_igns
rejig133810123rejig__
rejigs14368093rejig_s
reliant7319243reliant
relict83623903reli_ct
relighted1436863relighted
relish93916953relish_
relist64628413reli_st
relit55340683reli__t
remiges103015473remiges
remint85329973remi_nt
remit75737223remi__t
remixt155014853remi_xt
renig64518913renig__
renigs74314593renig_s
rerig64018483rerig__
rerigs74014793rerig_s
resift94017723resi_ft
resighted1436523resighted
resign74212583resig_n
resigns83910963resigns
resist64524533resi_st
resit54241043resi__t
resought1254983resought
retaught1244653retaught
retighten1374773retighten
retint65633443reti_nt
revisit10311373revisit
reweigh1464773reweigh_
reweighs1583203reweighs
righto104111093r__ighto
rights104019333r__ights
righty135011833r__ighty
sennight1245143sennight
sight94629293__sight
sleight11279023sleight
slight103416003_slight
spright132010403spright
tight93626503__tight
tonight1138743tonight
unsight1137483unsight
uplight13167363uplight
upright13178293upright
uptight13176033uptight
weigh125412513we_igh_
weighs13338873we_ighs
weights14409553we_ights
weighty17376233we_ighty
wight123725573__wight
wright133713513_wright

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271616.65620136.3
3Display Results1611610.0632555.6
 (SQL Overall)1786911617.10925135.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.