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

91 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
virtual104591(None) 
victual1246251victual
ritual6310622ri_tual
victuals1344772victuals
viral86419592vir__al
virtu85314092virtu__
virtually1544482virtually
virtue9358672virtu_e
virtues10338022virtues
virtus94310142virtu_s
visual938802vi_sual
vital84819672vi_t_al
actual8311023_actual
aortal65217513aort_al
artal55525473_art_al
brutal859383_brutal
citral81113893ci_tral
cornual94210173cornual
curtal83914543curt_al
dirtbag1143023dirtbag
distal73615773dist_al
estrual7367933estrual
eventual1144883eventual
factual1246723factual
fistula1045503fistula
hartal9415473hart_al
hiatal9310203hiat_al
irreal657833_irreal
lingual8379083lingual
martial92415413martial
mistral91013643mistral
mitral81314323mi_tral
mortal84616853mort_al
mutual838503_mutual
nurtural845493nurtural
partial92616263partial
portal84218463port_al
revictual1442693revictual
rictal83113183rict_al
rituals738353ri_tuals
rorqual1663573rorqual
spiritual1144253spiritual
tactual936203tactual
tertial7313863tertial
textual1444603textual
tissual745193tissual
ventral103612173ventral
verbal112513663ver_bal
vernal93514213ver_nal
versal93013753ver_sal
vertical13410433vertical
vertu85017613vertu__
vertus94613603vertu_s
vestal94615573vest_al
vestral104111013vestral
vestural1156473vestural
vial76731093vi___al
viatical1347063viatical
vicinal12268543vicinal
victualed1543103victualed
victualer1442633victualer
viminal12288823viminal
vinal85725813vi__nal
vincula1246393vincula
vineal94814743vi_neal
virelai1045593virelai
virelay1335943virelay
virga9310253vir_ga_
virgas1048883vir_gas
virginal1244573virginal
virgule1144283virgule
virl76224473vir___l
virtuality1644293virtuality
virtuosa1141943virtuosa
virtuosas1251953virtuosas
virtuose1143183virtuose
virtuosi1142123virtuosi
virtuoso1141873virtuoso
virtuous1144663virtuous
virus85316843vir_u_s
vista85416603vist_a_
vistas94513273vist_as
visuals1036853vi_suals
vita75828523vi_t_a_
vitae84217633vi_t_ae
vitals94514303vi_t_als
vitriol1045693vitriol
vitta85015173vi_tta_
vittae93911003vi_ttae
vortical1348863vortical
withal1238933wi_thal

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 Filter1786911340270.406440125.6
2DLD Change Limit134027915.78323176.0
3Display Results91910.0461978.3
 (SQL Overall)178691916.23528659.3
 
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.