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 “libelees” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 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
libelees1022721(None) 
libelee92510981libelee_
libelers10238621libelers
libellees11274981libellees
labelers10249412labelers
libeled10249412libel_ed
libeler9219002libel_er
libelled11317212libelled
libellee10227732libellee
libeller10297432libeller
libellers11236032libellers
libelous1047192libelous
libels85112692libel__s
lifeless11228142lifeless
limeless10249662limeless
lineless82711942lineless
abeles84719393_abel_es
alienees8118653ali_enees
belies84631053__belies
belles85325993__belles
bibelots1295133bibelots
bibles104617643bib_l_es
bibless11439173bib_less
cicelies1269753cicelies
dibblers13377583dibblers
dibbles124013333dibbl_es
fiberless1444443fiberless
fireless112810593fireless
gabelles11278933gabelles
gelees74116263__gelees
giblets103210423gib_lets
glebeless1242953glebeless
hideless12278713hideless
hiveless14227933hiveless
ibexes15436163_ibe_xes
iceless9219963_iceless
ireless72312243_ireless
jubilees17244423jubilees
kibbles153510253kibbl_es
labeled102510563label_ed
labeler92310183label_er
labelled11278293labelled
labeller10248073labeller
labellers11206553labellers
labels84515683label__s
laceless10239853laceless
levees93714523l__evees
levelers11259323levelers
libbers113812833lib_bers
libel74116103libel___
libelant1048563libelant
libelants1145303libelants
libeling1139873libeling
libelist10310823libelist
libelists1146953libelists
libellous1143633libellous
liberals1039413liberals
liberates111012933liberates
libers84721443lib__ers
liberties1149193liberties
liblabs1144123lib_labs
librates103412933librates
licencees13134643licencees
licences12129323licences
licensees1184473licensees
licenses10118923licenses
lichees123512783li_chees
lidless8309273li_dless
lieges74113443li_e_ges
liernes739623li_ernes
lifelines12147043lifelines
ligules82210913ligul_es
likelier1235283likelier
likeliest1346123likeliest
likeness12229863likeness
lilies63021413li__lies
limbless12246313limbless
limeades11116643limeades
lineages979183lineages
linerless936333linerless
lintless82710013lintless
lipless9259553li_pless
lisles63416283li_sl_es
listees73416673li_stees
listless8269263listless
liteness82213213liteness
littles73212783littl_es
livelier1136873livelier
liveliest1247093liveliest
liveners11217933liveners
liveness112411393liveness
liveries11314373liveries
lobelias1047203lobelias
lobelines1138563lobelines
lobules92510813lobul_es
loveless1168573loveless
lovelies1139893lovelies
melees83618083__melees
micelles1288833micelles
nibblers12306543nibblers
nibbles114011693nibbl_es
pileless1088623pileless
pipeless12107663pipeless
ribless93410343rib_less
riblets93412553rib_lets
tideless9269083tideless
tieless72512563ti_eless
timeless10239543timeless
tireless82510263tireless
tubeless1037023tubeless
viceless1337983viceless
wifeless14277483wifeless
wineless112711173wineless
wireless11249633wireless
zibelines2045723zibelines

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621156.62622058.9
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.82826170.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.