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

134 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
liblab103508(None) 
liblabs1144121liblabs
blab86629132__blab
kibla1139832kibla_
kiblah1535582kiblah
kiblas1239322kiblas
libra74712422libra_
librae84310172librae
libras83711702libras
lilac7311072li_lac
alible8311973alibl_e
bibb75819213bib__b
bible95119423bibl_e
bibles104617643bibles
blabs95619633__blabs
blae66134643__blae
blah98625063__blah
blam86131703__blam
blat66550953__blat
blaw97026723__blaw
bleb85425223__bleb
blob86027093__blob
blub85324873__blub
dobla84913643dobla_
doblas93812293doblas
fibula11258053fibula_
fibulae12237013fibulae
fibular12267973fibular
fibulas12228563fibulas
fila74729133fi_la_
filar84819293fi_lar
flab96628353__flab
giblet93418893giblet
glibly1236293glibl_y
hijab1736803hi_jab
hila76228353hi_la_
hilar85418143hi_lar
inlay85214323_inlay
jibb155816743jib__b
kabab134814443kab_ab
kebab134312003keb_ab
keblah1545313keblah
kiblahs1634153kiblahs
lab58864783___lab
labia75219013labia_
labial84714343labial
labra75415463labra_
lallan63414173lallan
liable81415813liabl_e
liana53915893liana_
lianas63713383lianas
liar47229683li__ar
lib57750273li___b
libber104414013libber
libel74116103lib_el
libelant1048563libelant
libeled10249413libeled
libelee92510983libelee
libeler9219003libeler
libels85112693libels
liber74723623lib_er
liberal9310193liberal
libers84721443libers
libido935753libido
library1245323library
librate93214233librate
libri74610113lib_ri
libs66732763lib__s
lidar6312723li_dar
lienal63912783lienal
ligan67920283li_gan
lignan75510323lignan
ligula7359673ligula_
ligulae8308753ligulae
ligular8348533ligular
ligulas8329173ligulas
lilacs837483li_lacs
lilo46731563li_l_o
lilos55821873li_los
lilt46349943li_l_t
lilts55822803li_lts
lily76730183li_l_y
lima65734133li_ma_
liman75921603li_man
limas75627633li_mas
limb85429383li__mb
limba95414983limba_
limbas105313203limbas
limpa97014463limpa_
limpas105513083limpas
linac7315413li_nac
lineal65616023lineal
linear65113343linear
linga66820823linga_
lingam95112353lingam
lingas75116573lingas
lipa68425923li_pa_
lira46928683li_ra_
liras56021983li_ras
lisle53916723lisl_e
lisles63416283lisles
litai55216363li_tai
litas54923773li_tas
lobar7313013lob_ar
lobular936663lobular
lullaby1243363lullaby
mihrab1335523mihrab
minilab11126003minilab
mislay113510683mislay
pibal95217323pib_al
pibals103813083pibals
pilaf103923483pi_laf
pilar75221503pi_lar
pilau73618523pi_lau
pilaw103913743pi_law
pillar8314023pillar
ribald9209293ribald
riblet84222443riblet
sibb85921423sib__b
sigla64515203sigla_
slab67133763__slab
tabla73318363tabla_
tablas83716163tablas
tibia7312403tibia_
tibiae838483tibiae
tibial849843tibial
tibias839953tibias
tilak91011553ti_lak
villa85321233villa_
villae95615383villae
villas96117263villas
viola85915543viola_
violas93713523violas
zillah1836563zillah

Search took 9 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 Filter1786911127160.780229091.0
2DLD Change Limit1127161348.07613956.9
3Display Results1341340.0462913.0
 (SQL Overall)1786911348.90220073.1
 
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.