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

133 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
liken91181884(None) 
lien45339811li_en
like86040851like_
liked104523811liked
likens105613701likens
liker95627061liker
likes96231901likes
limen75426031limen
linen55728721linen
liven85021731liven
alien56425582ali_en
alike95523962alike_
bike106532612bike_
biked125320032biked
biker116022562biker
bikes117529472bikes
dike95935772dike_
diked115024682diked
diker105524552diker
dikes105831332dikes
dikey135116422dikey
dizen155214932dizen
eikon939462eikon
gien56330032gi_en
given95915282given
hike116830402hike_
hiked135919202hiked
hiker125119392hiker
hikes125426982hikes
ikon85814962_ikon
ken76344002__ken
kike76524802kike_
kikes85122562kikes
laden65022192laden
lake85741602lake_
laked105731122laked
laker95432872laker
lakes95737652lakes
laten54328342laten
leben7314852leben
leke85527402leke_
liane54720662liane
libel74116102libel
liber74723622liber
lice66045072lice_
lichen114012742lichen
licked134621562licked
licker125222042licker
lie38264532li_e_
lied55838102li_ed
lief76037002li_ef
liens56525502li_ens
lier45942472li_er
lies46454202li_es
lieu46534372li_eu
life75433742life_
lifer85822152lifer
ligan67920282ligan
liger65024472liger
likely13328132likely
likened12267352likened
likers104620912likers
likest104914382likest
liking114319582liking
liman75921602liman
lime66244942lime_
limed85426802limed
limens84618032limens
limes75636502limes
limey104721042limey
limn66527702li_mn
lin37967382li__n
linden7411452linden
line46965582line_
lined64934642lined
linens64818392linens
lineny94011442lineny
liner55938922liner
lines57054572lines
liney87029632liney
linin58025522linin
linked114518212linked
linker104321472linker
linkmen1335362linkmen
linn46034602li_nn
lion46334452li_on
lipe66839742lipe_
lipin75518892lipin
lippen103911402lippen
lire47845302lire_
listen64816812listen
lite47054552lite_
liter54736342liter
litten64014872litten
live76541002live_
lived95523722lived
livens94314892livens
liver85132962liver
lives86133192lives
loden66621142loden
lumen75220902lumen
mien65028372mi_en
mike105535302mike_
miked125020452miked
mikes115129892mikes
mizen164815272mizen
oaken95814382oaken
pike106335222pike_
piked125623312piked
piker115622842piker
pikes115031032pikes
pinken124513282pinken
ripen75619262ripen
risen54621882risen
riven85121622riven
sicken124615252sicken
sike87138792sike_
siker95326032siker
sikes96236082sikes
silken104410852silken
siren54525822siren
slicken13309292slicken
taken94819142taken
tike85534492tike_
tikes95628902tikes
token95419312token
vimen104114752vimen
vixen153010022vixen
waken124818472waken
widen94717982widen
wizen175813862wizen
woken124614972woken
yikes125117752yikes

Search took 3 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.313570897.8
2DLD Change Limit538001331.62333148.5
3Display Results1331330.0462891.3
 (SQL Overall)1786911331.98290156.9
 
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.