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

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

68 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
virid9411604(None) 
irid55927171_irid
viroid10411521viroid
vivid125112311vivid
acrid86920102acrid
aired66032922aired
arid57642712_arid
bifid11910702bifid
bird76128322bir_d
fired94829742fired
gird65424992gir_d
grid65829612_grid
hired95226262hired
imid76122292_imid
ired55131872_ired
irids66417772_irids
iris45732552_iris
jerid132316422jerid
lipid85916172lipid
liri45128252liri_
livid96714422livid
lurid64618972lurid
mired85729222mired
miri66730372miri_
mirin75023152mirin
murid84520582murid
nitid61817832nitid
nitrid72812232nitrid
rid46754632__rid
rigid7913892rigid
sired66134282sired
timid84815732timid
tired65228902tired
valid94618392valid
vapid115614282vapid
varia85824202varia
varied104817862varied
varix154313512varix
verbid122311312verbid
viand9511072viand
vibrio1136222vibrio
viced115118182viced
vid77241812v__id
vied86328632vi_ed
vigia94813272vigia
vigil94313002vigil
vined95626152vined
vinic10314972vinic
viral86419592viral
vireo84816452vireo
vires84529682vires
virga9310252virga
virgin1038082virgin
virile9313432virile
virion9310682virion
virl76224472vir_l
virls85618602virls
viroids1137922viroids
virtu85314092virtu
virus85316842virus
viscid1237472viscid
vised95518762vised
visit8320962visit
vitric112510112vitric
vizir17359392vizir
void86220562v_oid
wired95327642wired
yird87018982yir_d

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit53800681.61033416.1
3Display Results68680.0164250.0
 (SQL Overall)178691681.93692299.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.