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

67 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
lychnis154438(None) 
lichis115212592lich_is
lychees15516782lychees
lyches144213612lych_es
lychnises1743762lychnises
chais107530313__chais
chins105631463__chins
chis95933313__ch_is
cochins141413103cochins
cyclins1438303cyclins
glycans1344233glycan_s
glycines1445083glycines
glycins1335563glycin_s
glyconic1644613glyconic
glyconics1743573glyconics
laches116528353lach_es
lacings105013653lacings
laconic1139883laconic
laconism1248043laconism
lacunas9138173lacunas
lacunes9159623lacunes
lashins103915153lashins
lathis95516173lath_is
lechers123313963lechers
leches115421313lech_es
leching134613653leching
lechwes1535063lechwes
lectins92515003lectins
lenis56326863l__enis
lichees123512783lichees
lichenin1345053lichenin
lichenins1444843lichenins
lichens123510683lichens
liches114724293lich_es
lichi104412953lich_i_
lichts113712383lich_ts
litchis1238373litch_is
lochans1248833lochans
lochia1158313loch_ia
lochs106715513loch__s
lycees11428863lyc_ees
lyceums1442403lyceums
lych126015763lych___
lychee143710893lych_ee
lycras11287253lyc_ras
lyings10488503ly_ings
lynchers16285453lynchers
lynches15378873lynch_es
lynching17336083lynching
lynchings18233503lynchings
lynchpin1842273lynchpin
lynchpins1942313lynchpins
lysines10369093lysines
lysins94610953lysin_s
lysis84511463ly__sis
mycosis1437763mycosis
orchis11710773orch_is
rachis114017653rach_is
syconia1248313syconia
sycosis1238823sycosis
technic1496903technic
technics1585463technics
technos1236183technos
urchins1238863urchins
wyches17387913wych_es
yonis85020823_y_onis
zechins21137123zechins

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.423422437.4
2DLD Change Limit134027676.50020619.5
3Display Results67670.0135153.8
 (SQL Overall)178691676.93625762.8
 
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.