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

148 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
revisit1031137(None) 
previsit13410071previsit
revisits1137421revisits
previsits1446792previsits
relist64628412relis_t
reposit9315862reposit
resist64524532resis_t
resit54241042re__sit
revest94623602reves_t
revisal1038262revisal
revise94019742revis_e
revised113815482revised
reviser104114662reviser
revises104220532revises
revising122714402revising
revision1138712revision
revisited1346572revisited
revisor10388732revisor
revuist1038472revuis_t
visit8320962__visit
bedsit9312843be_dsit
bemist105216963bemis_t
bevomit1445353bevomit
deficit1339673deficit
deist64633593de_is_t
delimit10311733delimit
delist74625053delis_t
deposit10313003deposit
desist74818813desis_t
devest104418703deves_t
deviant11311313deviant
devisal1136913devisal
devise104215753devis_e
devised123712563devised
devisee113812713devisee
deviser114212393deviser
devises114116763devises
devising133111523devising
devisor11357043devisor
elicit8417203_elicit
evict104417143_evi_ct
exist124618943_exis_t
feist86230073fe_is_t
heist87030913he_is_t
legist71315253legis_t
levis85818553levis__
lewisite1154543lewisite
merisis93213173merisis
neist54628443ne_is_t
prelimit1259123prelimit
previse123713793previs_e
prevised143611073prevised
previses133814283previses
prevising15510873prevising
prevision1448003prevision
previsited1645183previsited
previsor13116303previsor
racist82822793racis_t
raisin62716923r_aisin
rapist82520673rapis_t
ravish123414033ravis_h
readmit1039823readmit
realist73225383realis_t
rebait8320403re_bait
recast83422773recas_t
recision10310273recision
recit75235103re__cit
recruit939773recruit
redbait1039803redbait
redipt94116743redi_pt
reedit7617223re_edit
reemit8717223re_emit
reest54938093re_es_t
refight1488873refight
refit84230063re__fit
regilt71217493regi_lt
reis45343233re_is__
reknit10312533re_knit
reliant7319243reliant
relict83623903reli_ct
relight11512063relight
relish93916953relis_h
relists73817053relists
relit55340683re__lit
remint85329983remi_nt
remise84221953remis_e
remised103516843remised
remises93423483remises
remising112516453remising
remiss84216353remis_s
remit75737223re__mit
remixt155014853remi_xt
renest64529713renes_t
repast83520633repas_t
reposits10310453reposits
requisite1865423requisite
rerise64325633reris_e
rerisen73613643rerisen
rerises73525883rerises
rerising93017783rerising
resat55139683re__sat
reset55051863re__set
resid64124093re__sid
resift94017723resi_ft
resight11510643resight
resilin72913973resilin
resin54131053re__sin
resists74414923resists
resite64128453re__site
resits64725563re__sits
resplit9310373resplit
rest46459843re__s_t
retest64028453retes_t
retinite8314853retinite
retint65633443reti_nt
retwist1039483retwis_t
reverie103615163reverie
revert93529113rev_ert
revests104413733revests
revet84938843rev__et
review1238693revi_ew
reviews1335533reviews
revile94921613revi_le
reviled114417923reviled
reviler104314973reviler
reviles104421353reviles
reviling122917213reviling
revisals1136813revisals
revisers113511933revisers
revisions1238593revisions
revisiting1446953revisiting
revisors11379063revisors
revisory14306013revisory
revival1337033revival
revive124914823revi_ve
revived144211653revived
reviver134411373reviver
revives134715543revives
revivify2042923revivify
reviving152910503reviving
revolt9316223rev_olt
revs75027053rev_s__
revuists1135153revuists
seisin63715123se_isin
semifit1249973semifit
sexist133013483sexis_t
verist93823893veris_t
visits9311423__visits

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.843211970.3
2DLD Change Limit1340271487.42318055.6
3Display Results1481480.0463217.4
 (SQL Overall)1786911488.31221498.0
 
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.