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

50 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
filicides154594(None) 
filicide1446361filicide_
silicides1247071silicides
feticides1547002feticides
miticides1447082miticides
pulicides1446282pulicides
silicide1147832silicide_
viricides1545802viricides
algicides1344863algicides
biocides1336933bi_ocides
cilices113814023cilic__es
colicines13311203colicines
culicids1345623culicid_s
culicines1347013culicines
deicides1249303_deicides
felicities1549743felicities
feticide1447503feticide_
filches153410723fil_c_hes
filiates11412663fili_ates
filigrees1383263filigrees
fillies103420253fil_li_es
finitudes1344303finitudes
firesides1346603firesides
fixities1838213fixiti_es
fungicides1752453fungicides
hillsides1344553hillsides
homicides1745853homicides
ileitides1045613_ileitides
lipides103810623__lipides
medicides1556583medicides
miticide1347863miticide_
ovicides1445463_ovicides
policies122415663polici_es
pulicide1347043pulicide_
raticides1248693raticides
regicides1345813regicides
salicines11310003salicines
silicates11311523silicates
silicifies1544823silicifies
silicious1146433silicious
siliciums1384633siliciums
silicles1037073silic_les
silicones11106553silicones
silicoses1186183silicoses
sinicizes2046793sinicizes
suicides1139083_suicides
vaticides1546603vaticides
vilifies1439593vilifi_es
viricide1446423viricide_
virucides1543273virucides

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.420425454.8
2DLD Change Limit148641507.54619698.0
3Display Results50500.0163125.0
 (SQL Overall)178691507.98222386.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.