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

113 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
reviewer143413(None) 
previewer1743021previewer
reviewed1534821reviewed
reviewers1543891reviewers
previewed1843412previewed
previewers1842562previewers
reliever11448682reliever
renewer10248692re_newer
reveler104116342rev_eler
reverer103815832rev_erer
review1238692review__
reviewal1443512reviewal
reviews1335532review_s
reviler104314972revi_ler
reviser104114662revi_ser
reviver134411372revi_ver
viewer1237212__viewer
believer13448423believer
besieger1144673besieger
beveler124010683bev_eler
brevier1237763brevi__er
deviser114212393devi_ser
evener91010623_ev_ener
eviler94811893_evi_ler
eviller1056673_eviller
leveler10399903lev_eler
levier94013873levi__er
nonviewer1542753nonviewer
preview1536473preview__
previews1634513preview_s
raveler104212463rav_eler
ravener104110733rav_ener
ravisher1465463ravisher
receiver1337413receiver
rechewed1735633rechewed
reciter94117263reci_ter
redeemer1145323redeemer
redrawer1235313redrawer
reefer93314363re__efer
reeker103715593re__eker
reeler63822573re__eler
refilter1137153refilter
refiner105316913refi_ner
reflower14126843reflower
register939553register
reifier103414523re_ifier
reinter73116843re_inter
reiver95318293re_i_ver
rejigger1743183rejigger
relier65826183reli__er
relieve105010693relieve_
relieved12438513relieved
relievers12387063relievers
relieves114210393relieves
reminder113110513reminder
remitter102810323remitter
renderer9239743renderer
reneger8299493re_neger
renewed11309993re_newed
renewers11238183re_newers
repiner94816903repi_ner
repower12329883re_power
rereviewed1741993rereviewed
resewed113011823re_sewed
reshower14107063reshower
resider84615803resi_der
resigner937793resigner
resilver11337503resilver
resister8311653resister
retirer74715013reti_rer
retriever1284213retriever
revamper1533533revamper
revealer113110073revealer
reveled113917753rev_eled
revelers113414133rev_elers
reveller112912183reveller
revenger1237303revenger
revenuer1136893revenuer
revere94621253rev_ere_
revered112819333rev_ered
reverers113113153rev_erers
reveres103621343rev_eres
reverser113010483reverser
reverter114812873reverter
reviewals1542963reviewals
reviewing1635513reviewing
revile94921613revi_le_
reviled114417923revi_led
revilers114011693revi_lers
reviles104421353revi_les
revise94019743revi_se_
revised113815483revi_sed
revisers113511933revi_sers
revises104220533revi_ses
revisor10388733revi_sor
revive124914823revi_ve_
revived144211653revi_ved
revivers14389633revi_vers
revives134715543revi_ves
revoker14419193rev_oker
revolter11279363revolter
revolver14287713revolver
rewinder12317663rewinder
riever94811653r__iever
riveter10208753riv_eter
riviere1036373riviere_
rivieres1136013rivieres
severer103511563sev_erer
televiewer1652083televiewer
unreviewed1742623unreviewed
viewed1345993__viewed
viewers1337173__viewers
viewier1334983__viewier

Search took 7 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621136.62322068.9
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.84226116.8
 
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.