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

131 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
lamella98860(None) 
labella988941labella
lamellae10117021lamellae
lamellar1096481lamellar
lamellas1098151lamellas
camelia11510432camelia
camellia1255432camellia
canella9310792canella
favella1336172favella
flabella1344962flabella
flagella1244562flagella
glabella1144272glabella
lamellate11116692lamellate
lamely114013222lame_ly
latilla737952latilla
paella8410912pa_ella
patella938952patella
abelia83114403_abelia
abolla8410193_abolla
akela9311343_ake_la
alameda1035493alame_da
ameba9312383_ame_ba
ampulla1164303_ampulla
areola6813673_areola
armilla936993armilla
avellan1037293_avellan
axilla13289573_axilla
barilla9310323barilla
bumelia1145263bumelia
cadelle1039913cadelle
calla74827073ca__lla
camel96822803came_l_
camelias12510293camelias
camelid1249393camelid
camellias1365073camellias
camels105217083came_ls
camera10313673came_ra
cameral11311263cameral
canellas10310563canellas
cavalla1257883cavalla
cella75420313__cella
clitella1043673clitella
columella1352663columella
favela1237033fave_la
favellas1446163favellas
fella84918653__fella
flagellar1343813flagellar
gabelle10259213gabelle
gamelan10106643gamelan
gamely124711913game_ly
gametal1037603gametal
gazelle17236333gazelle
glabellae1243743glabellae
glabellar1243243glabellar
hazelly2254383hazelly
kamala12339963kam_ala
label75019383labe_l_
labeled102510563labeled
labeler92310183labeler
labellate11126923labellate
labelled11278293labelled
labeller10248073labeller
labellum1274273labellum
labels84515683labe_ls
lall45531313la__ll_
lallan63414173la__llan
lalls55324133la__lls
lama66635293lam___a
lambada1245643lambada
lambda1146113lam_bda
lame66849293lame___
lamed85235293lame__d
lamedh12476363lame_dh
lamedhs13444703lamedhs
lameds94812033lame_ds
lamellose1143523lamellose
lament85024943lame_nt
laments94314853laments
lamer75233703lame__r
lames75445543lame__s
lamest84722763lame_st
lamia75324323lam__ia
lamina84920443lam_ina
laminal94113633laminal
lanely93914483lane_ly
lapel73716683lape_l_
lapeled10258893lapeled
lapelled11227083lapelled
lapels83712043lape_ls
lapilli945643lapilli
lately93413843late_ly
lateral7313563lateral
latillas847363latillas
levelly1335843levelly
lobelia947213lobelia
lomenta92710133lomenta
lumenal9307273lumenal
mammilla1143933mammilla
manilla93012473manilla
maxilla16248193maxilla
mell64935613__mell_
mells75031333__mells
micella11106823micella
mulla74317113__mulla
nacelle938153nacelle
namely113711323name_ly
nigella844523nigella
novella1076213novella
paellas9411413pa_ellas
papilla11127913papilla
patellae1047623patellae
patellar1046863patellar
patellas1039103patellas
rambla103510933ram_bla
ramenta9311183ramenta
ramtilla1054733ramtilla
ravelly13268353ravelly
rubella9146523rubella
smell74916233_smell_
smells83914743_smells
smelly114110353_smelly
stella63612973_stella
tambala1138023tambala
tamely113711953tame_ly
tampala1136613tampala
tramell9398703tramell_
tramells10327833tramells
vanilla10238743vanilla
walla85321033wa__lla
yamalka1652963yamalka
yamulka1651773yamulka

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271317.98616782.7
3Display Results1311310.0462847.8
 (SQL Overall)1786911318.18821823.5
 
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.