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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
revisited134657(None) 
previsited1645181previsited
relisted9312622relis_ted
reposited1239132reposited
resisted9312692resis_ted
resited85122422re__sited
revested122612242reves_ted
revised113815482revis__ed
revisit10311372revisit__
revisits1137422revisit_s
unvisited1345172unvisited
visited1168772__visited
bemisted1368383bemis_ted
bevomited1742773bevomited
delimited1346593delimited
delisted10310563delis_ted
deposited1346773deposited
desisted1039783desis_ted
devested13239133deves_ted
deviated13311043devi_ated
devised123712563devis__ed
elicited1139093_elicited
evicted1337243_evi_cted
evited104013143_ev__ited
existed1538473_exis_ted
heisted113210653he_is_ted
levigated1445643levigated
levitated1346413levitated
lewisite1154543lewisite_
lewisites1244213lewisites
prelimited1545493prelimited
prevised143611073previs__ed
previsioned1744263previsioned
previsit13410073previsit__
previsits1446793previsit_s
ravished1555713ravis_hed
rebaited11410543re_baited
recited104319103re__cited
recruited1236453recruited
redbaited1344713redbaited
redivided1544253redivided
reedited10310083re_edited
reested82916233re_es_ted
refitted12309413refi_tted
register939553regis_ter
reified112913783re_ifi_ed
reignited1145683reignited
reincited1246853reincited
reinvited1386193reinvited
reissued944903re_issued
relighted1436863relighted
relished1239433relis_hed
reminted113615083remi_nted
remised103516843remis__ed
remitted113312073remi_tted
renested92212953renes_ted
repasted112611533repas_ted
requisite1865423requisite_
requisites1964503requisites
requited18169723re_quited
resided95217703re__sided
resifted12310153resi_fted
resighted1436523resighted
resiled84621983re__siled
resinated10413283resinated
resined84522653re__sined
resister8311653resis_ter
resite64128453re__site_
resites74027793re__sites
resized174614903re__sized
respited11410813re_spited
rested74430783re__s_ted
retasted92412113retas_ted
retested92212533retes_ted
retinite8314853retinite_
retinites9313503retinites
retinted94414363reti_nted
retwisted1344893retwis_ted
reunited939713re_united
reverted122714713rev_erted
revetted122210943rev_etted
revibrated1645443revibrated
reviewed1534823revi_ewed
reviled114417923rev__iled
reviolated1446253reviolated
revise94019743revis__e_
reviser104114663revis__er
revises104220533revis__es
revising122714403revisi_ng
revision1138713revisi_on
revisions1238593revisions
revisiting1446953revisiting
revived144211653rev__ived
revivified2043833revivified
revoiced14317873rev_oiced
revolted12319863rev_olted
revoted114314153rev__oted
visiter1038863__visiter

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 Filter1786911486410.423422437.4
2DLD Change Limit148641986.81321817.3
3Display Results98980.0761289.5
 (SQL Overall)178691987.31224438.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.