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

64 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
unvisited134517(None) 
revisited1346572revisited
unlimited1245922unlimited
unlisted9311152unlis_ted
unvested122210222unves_ted
visited1168772__visited
enlisted978193enlis_ted
envisaged1442063envisaged
envisioned1452933envisioned
inhibited1544763inhibited
insisted998673insis_ted
invested12229693inves_ted
invited113612463inv__ited
previsited1645183previsited
unassisted1143833unassisted
unaudited1145853unaudited
unbasted112510073unbas_ted
unbigoted1343993unbigoted
unbitted1138213unbi_tted
unbusted11258773unbus_ted
unciliated1348053unciliated
undesired1147523undesired
undiluted1144903undiluted
undisputed1442313undisputed
undivided1544303undivided
unedited10249833un_edited
unexcited1953983unexcited
unfished15218293unfis_hed
unfitted1238163unfi_tted
ungifted13116833ungi_fted
unified112413573un_ifi_ed
uninvited1344883uninvited
unisize1647343un_isize_
unissued934683un_issued
united74421543un___ited
unitized1839233un_itized
unkissed1334893unkis_sed
unlighted1455783unlighted
unmerited1239643unmerited
unpitied1138793unpiti_ed
unpitted1148623unpi_tted
unplaited1236883unplaited
unposted1159433unpos_ted
unrested91914513unres_ted
unrusted92310353unrus_ted
unsated83419933un__sated
unsifted12128773unsi_fted
unsighted1455433unsighted
unsized172510543un__sized
unsuited9310793un_suited
untasted92011573untas_ted
untested92612413untes_ted
untidied1038903untidi_ed
untilted9610893unti_lted
untwisted1344863untwis_ted
ununited938683un_united
unvaried1239683unvari_ed
unveiled1298163unv_eiled
unveined1258003unv_eined
unvoiced14106303unv_oiced
unwasted12259783unwas_ted
unwished15237833unwis_hed
unwitted1237543unwi_tted
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.1561145455.1
2DLD Change Limit148641647.00021234.4
3Display Results64640.0164000.0
 (SQL Overall)178691647.17224915.1
 
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.