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

149 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
laminals1033930(None) 
laminal94113631laminal_
laminas93615871lamina_s
labials9299872labi_als
lamias85020612lami_a_s
lamina84920442lamina__
laminable1337122laminable
laminae93512972lamina_e
laminar93810282lamina_r
laminary13337252laminary
laminate103014632laminate
laminates112712902laminates
laminins1039132laminins
laminous1037952laminous
lanitals837722lanitals
latinas74416462latina_s
liminal93810672liminal_
luminal93711002luminal_
nominals10278612nominals
admirals1144353admirals
albinal937813albinal_
almanacs1254443almanacs
aluminas1048353alumina_s
amias75831473_ami_a_s
amidols10457563_amidols
amigas95912173_amiga_s
amines84727983_amin_es
amins75534323_amin__s
ammonals1245403ammonals
animals94111703_animals
annals66415923_a_nnals
apicals1159923_apicals
basinal9310033basinal_
cacuminals1662643cacuminals
camisas113411923camisa_s
canals84421663ca__nals
capitals12209443capitals
cardinals1247993cardinals
carinal94318233carinal_
carinas93622403carina_s
criminals1346293criminals
damianas1155573damianas
facials123310743faci_als
famines123216263famin_es
farinas103215233farina_s
finals94316163__finals
flamines13311643flamin_es
flamingly1845023flamingly
flamingos15293093flamingos
gamines103618463gamin_es
gaminess112911063gaminess
gamings114610913gamin_gs
gamins94420053gamin__s
gavials1136603gavi_als
geminal10109913geminal_
hamals114816823ham__als
hammals14409223ham_mals
hymnals1543523hym_nals
jarinas143712183jarina_s
labial84714343labi_al_
laciness102112553laciness
lacings105013653lacin_gs
lacrimals1342913lacrimals
lacteals1095663lacteals
lacunal9136553lacunal_
lacunars10114733lacunars
lacunas9138173lacuna_s
ladings93814133ladin_gs
ladinos8389963ladin_os
lagunas8156823laguna_s
laical8312323la_ical_
lakings124713513lakin_gs
lamas75532793lam__a_s
lambdas1246243lambda_s
lamellas1098163lamellas
lameness102612673lameness
laments94314853lamen_ts
lamia75324323lami_a__
lamiae84817453lami_a_e
laminaria1145183laminaria
laminarias1245323laminarias
laminarin1146083laminarin
laminarins1245873laminarins
laminated122610283laminated
laminator1147553laminator
laminators1247053laminators
laming94528363lamin__g
laminin939973lamin_in
laminitis1146243laminitis
laminose1036913laminose
lampads12477623lam_pads
lampas106615953lam_pa_s
lanais6316793la__nais
lanital7310913lanital_
lapins84520683lapin__s
lariats7615053lari_ats
laryngals1342513laryngals
laterals8312753laterals
latillas847363latillas
latina65621143latina__
latinos73613803latin_os
lawines103313563lawin_es
lawings113611473lawin_gs
layins93817653layin__s
laziness17239983laziness
limina83514503limina__
liminess10510643liminess
linacs8310813l__inacs
loaminess1137493loaminess
lumenal9307273lumenal_
lumina84613543lumina__
luminary13336653luminary
luminous1037113luminous
mammals10389273mam_mals
marginals1246003marginals
marinas93519383marina_s
matinal9312603matinal_
maximals19325223maximals
minas75434113__mina_s
nationals948863nationals
nominal92712373nominal_
ordinals946753ordinals
paginal10269493paginal_
patinas96318523patina_s
platinas103610313platina_s
radials83614633radi_als
radicals112610153radicals
ramonas9311093ramona_s
rationals949943rationals
retinals85612963retinals
ruminal9289993ruminal_
sahiwals1443643sahiwals
salinas73116093salina_s
sambals115213483sam_bals
samiels939763sami_els
seminal91213413seminal_
seminars1079053seminars
spinals93911863_spinals
staminal1046983staminal_
staminas1048853stamina_s
tamals84116633tam__als
terminals1147453terminals
urinals7610253_urinals
vaginal11288403vaginal_
vaginas11298813vagina_s
viminal12288823viminal_
vinals94716483__vinals
zamias174212923zami_a_s
zamindars2142363zamindars

Search took 8 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.436409841.7
2DLD Change Limit1461621497.20320291.8
3Display Results1491490.0502980.0
 (SQL Overall)1786911497.68923239.8
 
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.