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 “rewin” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

119 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
rewin8562396(None) 
rawin85521471rawin
rein46040891re_in
renin54830031renin
repin75324701repin
resin54131051resin
rewan85623661rewan
rewind104715881rewind
rewins95020821rewins
rewon86920581rewon
begin85117352begin
bewig1138902bewig
brewing133411152brewing
brewis11469982brewis
cretin82917912cretin
crewing133212632crewing
dewan95718042dewan
dewing114115702dewing
hemin103620932hemin
hewing134514242hewing
hewn106719852hew_n
jewing174411422jewing
levin84816412levin
lewis85315842lewis
mewing123914202mewing
newie81813482newie
pein65834942pe_in
pekin111514422pekin
pewit104622792pewit
rain46251732r_ain
ravin85624652ravin
rawins95617622rawins
reagin74915532reagin
rebid85121362rebid
rebind94416932rebind
recit75235102recit
recoin84320292recoin
recon75624242recon
redan66125012redan
redfin10310222redfin
redia65524482redia
redid74922392redid
reding83825562reding
redip87816962redip
redon65424882redon
redwing122811982redwing
refind104717072refind
refine95225692refine
refit84230062refit
refix155212482refix
regain74517762regain
regina75317142regina
region74614902region
rei35647252re_i_
reif76937652re_if
reign65015192reign
reink95518092re_ink
reins56234562re_ins
reis45343232re_is
rejig133810122rejig
rejoin134012242rejoin
relic74623362relic
reline65434352reline
relink104415922relink
relit55340682relit
remain85919862remain
reman75730152reman
remind94819792remind
remint85329982remint
remit75737222remit
remix145916552remix
renig64518912renig
renins64526452renins
rennin63914032rennin
reoil55321182reoil
repine85627812repine
repins84924312repins
requin15310712requin
reran57329102reran
rerig64018482rerig
rerun58722152rerun
resid64124092resid
resign74212582resign
resins64528772resins
resiny94617362resiny
resit54241042resit
retain64523282retain
retia55326112retia
retie55735302retie
retina65023382retina
retine66237332retine
retint65633442retint
rewax155713922rewax
rewed95425452rewed
rewet85135152rewet
rewiden1137532rewiden
rewinds114810482rewinds
rewire95421412rewire
reworn98122202reworn
rexine134719442rexine
ricin74620212ricin
rin36663182r__in
robin74820282robin
rosin55325312rosin
rowan85418732rowan
rowen84921152rowen
rowing103623302rowing
ruin47430512r_uin
rutin55421342rutin
serin55434442serin
sewan85921292sewan
sewing103819622sewing
sewn76124332sew_n
tewing103914822tewing
twin76023082_twin
vein75625752ve_in
venin85118662venin
win66456292__win
zein135620602ze_in

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001191.59333772.8
3Display Results1191190.0462587.0
 (SQL Overall)1786911191.95291542.5
 
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.