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

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
libelous104720(None) 
libellous1143641libellous
bibelots1295132bibelots
bibulous1244642bibulous
libelees10227212libelees
libelers10238622libelers
libels85112692libel__s
acoelous1047023acoelous
belons84119413__belons
belows114614183__belows
bibelot1167343bibelo_t
dimerous1139323dimerous
fabulous1344853fabulous
fibrous1237593fib_rous
gibbous1265333gib_bous
hideous1168433hide_ous
kabeljous2251663kabeljous
labelers10249413labelers
labellum1274283labellum
labels84515683label__s
libel74116103libel___
libelant1048563libelant
libelants1145303libelants
libeled10249413libel_ed
libelee92510983libel_ee
libeler9219003libel_er
libeling1139873libeling
libelist10310823libelist
libelists1146953libelists
libelled11317213libelled
libellee10227733libellee
libellees11274983libellees
libeller10297433libeller
libellers11236033libellers
liberals1039413liberals
libers84721443libe__rs
libidos1044653libido_s
liblabs1144123lib_labs
lichenous1444313lichenous
lieus56218483li_e__us
lifeless11228143lifeless
lifelong1242633lifelong
ligneous945233ligneous
lilos55821873li__lo_s
limeless10249663limeless
limulus935083limul_us
linalols844903linalols
lineless82711943lineless
livelong1243403livelong
lobelias1047203lobelias
luteous739273lute_ous
nebulous1045103nebulous
nickelous1553423nickelous
niveous1037193nive_ous
nubilous1044853nubilous
obelus8348403_obel_us
piceous11310693pice_ous
pileous9510523pile_ous
pilous84717753pi__lous
piteous9310683pite_ous
sabulous1046123sabulous
suberous10311803suberous
timeous938403time_ous
tuberous1047503tuberous
tubulous1045383tubulous
villous102810023vi_llous
viperous1347613viperous
vitellus1144143vitellus

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 Limit146162686.86021306.4
3Display Results68680.0302266.7
 (SQL Overall)178691687.31324434.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.