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

66 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
ligneous94523(None) 
igneous835771_igneous
aeneous739893_aeneous
aligners9117573aligne_rs
bigamous1385503bigamous
bigness1038193bigne_ss
biogenous1244853biogenous
cineols9128853ci_neols
citreous1056853citreous
corneous10310033corneous
digamous1296063digamous
epigenous1245353epigenous
epigeous1146533epig_eous
hideous1168433hi_deous
hugeous1137133hug_eous
idoneous944573idoneous
lacteous1046773lacteous
lianes63819323liane__s
libelous1047193libelous
lichenous1444313lichenous
lieus56218483li__e_us
ligers75022043lig_e_rs
lignaloes1054033lignaloes
lignans8398853lign_ans
lignins84010493lign_ins
lignites9129613lignites
limners93311563limne_rs
linecut997983li_necut
linecuts1094553li_necuts
linens64818393li_ne_ns
liners65428853li_ne_rs
lines57054573li_ne__s
lineup835983li_ne_up
lineups934913li_neups
lingcods1243943lingcods
lingers84223303linge_rs
lingoes84014693li_ngoes
linnets739833linne_ts
linos55631503li_n_o_s
lintols7339553li_ntols
lioness739103lione_ss
longevous1343453longevous
luteous739273l_uteous
mignons1037863mign_ons
niveous1037193ni_veous
piceous11310693pi_ceous
pigeons1039183pig_eons
pignus937953pign__us
pileous9510523pi_leous
piteous9310683pi_teous
righteous1345073righteous
rigorous947373rigorous
signees83510803signe_es
signers84714443signe_rs
signets83311503signe_ts
signiors944923signiors
signors83410913sign_ors
sinuous739063si_nuous
timeous938403ti_meous
vignerons1343163vignerons
vigorous1245763vigorous
vimineous1443083vimineous
vinous93914173vi_n_ous
vitreous1145843vitreous
wigeons1136983wig_eons
zincous1837053zi_ncous

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 Filter1786911461620.423422437.4
2DLD Change Limit146162666.93621073.0
3Display Results66660.0332000.0
 (SQL Overall)178691667.39224173.6
 
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.