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

116 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
resid6412409(None) 
rebid85121361rebid
redid74922391redid
resaid74517081resaid
reside74224931reside
resids74219151resids
resin54131051resin
resit54241041resit
resod64720051resod
beside95114612beside
cebid104314072cebid
desmid1048362desmid
felid94717172felid
fetid93715982fetid
gelid74916982gelid
geoid74215762geoid
jerid132316422jerid
mesic93617862mesic
mysid11610692mysid
prebid113512842prebid
preside10715612preside
rabid84520782rabid
raid55243072r_aid
ranid66429332ranid
rapid86422032rapid
rased65033932rased
read55942532re_ad
readd74617132readd
rebids94015532rebids
rebind94416932rebind
recit75235102recit
red46755802re__d
redd66323172re_dd
reded74829122reded
redia65524482redia
redip87816962redip
reed55549622re_ed
refed93921922refed
refind104717072refind
refit84230062refit
refix155212482refix
regild8149772regild
rei35647252re_i_
reif76937652re_if
rein46040892re_in
reis45343232re_is
rejig133810122rejig
relaid75518442relaid
relic74623362relic
relied74926232relied
relit55340682relit
remind94819792remind
remit75737222remit
remix145916552remix
rend56136572re_nd
renig64518912renig
renin54830032renin
reoil55321182reoil
repaid94716322repaid
repin75324702repin
rerig64018482rerig
res35565042res__
resail64418732resail
resat55139682resat
resaw84117252resaw
resay85320542resay
rescind10410392rescind
reseda739702reseda
resee54336332resee
reseed74823292reseed
resend75016772resend
reset55051862reset
resew84519502resew
resh76523452res_h
reship11310672reship
reshod103012232reshod
resided95217702resided
resider84615802resider
resides84523282resides
residua8286622residua
residue8689862residue
resift94017722resift
resign74212582resign
resile64627672resile
resiled84621982resiled
resined84522652resined
resins64528772resins
resiny94617362resiny
resist64524532resist
resite64128452resite
resited85122422resited
resits64725562resits
resize154117722resize
resized174614902resized
resods74116302resods
resold73915362resold
resow88217242resow
rest46459842res_t
rested74430782rested
rests54935872rests
retia55326112retia
retie55735302retie
retied75924982retied
reused75419562reused
rewed95425452rewed
rewin85623962rewin
rewind104715882rewind
rid46754632r__id
rigid7913892rigid
rosed65930342rosed
rosin55325312rosin
teiid6312532teiid
tepid8314312tepid
trepid9310082trepid
ursid6311482ursid
vespid1246082vespid

Search took 3 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.343520965.0
2DLD Change Limit538001161.62333148.5
3Display Results1161160.0333515.2
 (SQL Overall)1786911161.99989390.2
 
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.