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

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

102 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
libel7411610(None) 
label75019381label
libels85112691libels
liber74723621liber
alible8311972alible
babel95821692babel
bel57148462__bel
bible95119422bible
cibol9512022cibol
diel59034602di_el
fiber104921132fiber
gibe75927782gibe_
gibed96215962gibed
giber85417702giber
gibes84422522gibes
gimel8313352gimel
ibex133813482_ibex
jebel145612142jebel
jibe136323392jibe_
jibed155114162jibed
jiber145115702jiber
jibes145520322jibes
kibe106523442kibe_
kibei114311532kibei
kibes115521112kibes
labels84515682labels
lapel73716682lapel
leben7314852leben
level84116552level
liable81415812liable
lib57750272lib__
libber104414012libber
libeled10249412libeled
libelee92510982libelee
libeler9219002libeler
liberal9310192liberal
libers84721442libers
libra74712422libra
libri74610112libri
libs66732762lib_s
lice66045062lice_
lie38264522li_e_
lied55838092li_ed
lief76036992li_ef
lien45339802li_en
lier45942462li_er
lies46454192li_es
lieu46534362li_eu
life75433732life_
lifer85822152lifer
liger65024472liger
like86040842like_
liked104523812liked
likely13328132likely
liken911818842liken
liker95627062liker
likes96231902likes
limbed114513182limbed
limber104316792limber
lime66244932lime_
limed85426802limed
limen75426032limen
limes75636502limes
limey104721042limey
line46965572line_
lineal65616022lineal
lined64934642lined
linen55728722linen
liner55938922liner
lines57054572lines
liney87029632liney
lintel64013992lintel
lipe66839732lipe_
lire47845292lire_
lisle53916722lisle
listel64214742listel
lite47054542lite_
liter54736342liter
live76540992live_
lived95523722lived
lively123310812lively
liven85021732liven
liver85132962liver
lives86133192lives
lobe65535362lobe_
lobed86022132lobed
lobes75331002lobes
losel54419422losel
lube64731562lube_
lubed85319892lubed
lubes74727992lubes
pibal95217322pibal
pixel143911902pixel
rebel73421292rebel
ribes75530172ribes
riel46432382ri_el
rubel75416832rubel
sibyl1037112sibyl
umbel93612842umbel
vibe95124502vibe_
vibes104719952vibes
zibet16419732zibet

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001021.67332157.8
3Display Results1021020.0137846.2
 (SQL Overall)1786911021.779100444.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.