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

63 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
viricides154580(None) 
viricide1446421viricide_
virucides1543271virucides
filicides1545942filicides
miticides1447082miticides
silicides1247072silicides
vaticides1546602vaticides
verbicides18104372verbicides
vermicides1894912vermicides
viricidal1543842viricidal
virilizes2146952virilizes
virucide1443592virucide_
acaricides1543943acaricides
algicides1344863algicides
biocides1336933bi_ocides
deicides1249303_deicides
feticides1547003feticides
filicide1446363filicide_
firesides1346603firesides
germicides1684113germicides
herbicides1884193herbicides
homicides1745853homicides
irides74519123_ir__ides
iritises839973_iritises
larvicides1663213larvicides
liripipes1342793liripipes
lyricises149810873lyricises
lyricizes23787843lyricizes
matricides1545983matricides
medicides1556583medicides
miticide1347863miticide_
ovaritides1443973ovaritides
ovicides1445463_ovicides
parricides1545553parricides
patricides1546283patricides
piracies12312643piraci_es
pulicides1446283pulicides
raticides1248693raticides
regicides1345813regicides
silicide1147833silicide_
sinicizes2046793sinicizes
sporicides1544443sporicides
suicides1139083_suicides
uxoricides2052273uxoricides
varices123313573varic__es
varicoses1446653varicoses
vaticide1446863vaticide_
verbicide1784633verbicide_
verifies141313483verifi_es
verities111418043veriti_es
vermicide1785253vermicide_
vilifies1439593vilifi_es
vinifies1439873vinifi_es
viridians1343673viridians
viridities14106903viridities
virilisms1446243virilisms
virilities1379123virilities
virilize2047743virilize_
virilized2246233virilized
viroids1137923vir_oid_s
virucidal1552453virucidal
vitrifies1547223vitrifi_es
vivifies1747023vivifi_es

Search took 16 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 Filter1786911486411.046170832.7
2DLD Change Limit1486416314.09310547.2
3Display Results63630.0331909.1
 (SQL Overall)1786916315.17211777.7
 
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.