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

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

67 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
eyelash134456(None) 
eyewash1642581eyewash
eyeglass1263332eyeglass
eyelashes1542852eyelashes
eyeless1058052eyeless
akelas10311193akelas_
byelaw1444253byela_w
byelaws1533263byelaws
calash11312433_calash
chelas113817203chelas_
clash106219033__clash
cyclase1436613cyclase
deash95617243_de_ash
delish105215613_delish
edemas9310503edemas_
eels46536743e_el_s_
emdash12244113e_mdash
encash11276943e_ncash
enclasp1145843enclasp
endash10297123e_ndash
enemas8812003enemas_
english1137953english
enolase7310193enolase
euclase938933euclase
eyas76427433ey__as_
eyass84410783ey__ass
eyeball1245063eyeball
eyebar1135323eyeba_r
eyebars1245333eyebars
eyeblack19102733eyeblack
eyelet9514533eyel_et
eyelets1057523eyelets
eyelid1038443eyel_id
eyelids1135943eyelids
eyelift1396383eyelift
eyelike1436973eyelike
eyers86521333eye_rs_
eyes75837883eye__s_
eyewashes1842163eyewashes
eyras84715923ey_ras_
flash115716213__flash
goulash1164273goulash
hyenas1288953hyenas_
hylas114815903hy_las_
lash76539653___lash
leash85519213_le_ash
nyalas936903nyalas_
pearlash1344133pearlash
plash104616563__plash
prewash1535213prewash
rehash1237433_rehash
relish93916953_relish
rewash1237673_rewash
selah8319613_sela_h
selahs9313213_selahs
slash84719683__slash
splash1168823_splash
unlash938793_unlash
unleash1034963unleash
welsh113110363_wel_sh
yeah106725413_ye_a_h
yeahs115214553_ye_ahs
yeas78638423_ye_as_
yeast85327943_ye_ast
yelks126413623_yelks_
yells85821943_yells_
yelps105712993_yelps_

Search took 7 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.406440125.6
2DLD Change Limit134027676.09321996.9
3Display Results67670.0164187.5
 (SQL Overall)178691676.51527427.6
 
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.