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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

62 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
laminas9361587(None) 
lamias85020611lami_as
lamina84920441lamina_
laminae93512971laminae
laminal94113631laminal
laminals10339311laminals
laminar93810281laminar
latinas74416461latinas
aluminas1048352aluminas
amias75831472_ami_as
amigas95912172_amigas
amines84727982_amines
amins75534322_amin_s
camisas113411922camisas
carinas93622412carinas
damianas1155572damianas
famines123216262famines
farinas103215242farinas
flamines13311642flamines
gamines103618462gamines
gamings114610912gamings
gamins94420052gamin_s
jarinas143712192jarinas
lacings105013652lacings
lacunas9138172lacunas
ladings93814132ladings
ladinos8389962ladinos
lagunas8156822lagunas
lakings124713512lakings
lamas75532792lam__as
lambdas1246242lambdas
laments94314852laments
lamia75324322lami_a_
lamiae84817452lami_ae
laminary13337252laminary
laminate103014632laminate
laminates112712902laminates
laming94528362lamin_g
laminin939972laminin
laminins1039132laminins
laminose1036912laminose
laminous1037952laminous
lampas106615952lam_pas
lapins84520682lapin_s
latina65621142latina_
latinos73613802latinos
lawines103313562lawines
lawings113611472lawings
layins93817652layin_s
limina83514502limina_
liminal93810672liminal
lumina84613542lumina_
luminal93711002luminal
marinas93519392marinas
minas75434112__minas
patinas96318522patinas
platinas103610312platinas
ramonas9311092ramonas
salinas73116092salinas
staminas1048852staminas
vaginas11298812vaginas
zamias174212922zami_as

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit107671623.37631893.1
3Display Results62620.0302066.7
 (SQL Overall)178691623.77947285.3
 
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.