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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 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
ylem921789(None) 
xylem1736121xylem
ylems1039261ylems
ahem97225362ahem
ale36572342ale_
alec66430062alec
alee46652322alee
alef76340692alef
ales47067102ales
alme65832162alme
alum65227612alum
blam86131702blam
bleb85425222bleb
bled75729312bled
blet66247672blet
blew94722432blew
clam86332292clam
clef97028182clef
clew95520572clew
deem75432892deem
elemi7312502elemi
elm57531742el_m
em49445152__em
fem86040732_fem
flam96333292flam
flea75628492flea
fleam106017282fleam
fled85429772fled
flee76238792flee
flew105824252flew
flex146123472flex
fley106626852fley
gem66840222_gem
glam76529342glam
gleam86916732gleam
gled65631142gled
glee55239062glee
gleg66219802gleg
glen56027202glen
gley85724652gley
glim76026352glim
glom75424382glom
glum75825102glum
golem8416112golem
haem95730982haem
helm95530022helm
hem86148732_hem
idem76121062idem
ilea45931462ilea
ileum74512822ileum
ilex115822032ilex
item65620382item
lam57666712_lam
lea37660182_lea
led46254552_led
lee36068142_lee
leg46446112_leg
lei36846382_lei
lek75640302_lek
les35663072_les
let36481472_let
leu36047402_leu
lev66139422_lev
lex107943822_lex
ley66246812_ley
lez125541312_lez
lum55542932_lum
lye66533412lye_
lyes75530832lyes
mem77943472_mem
neem67328082neem
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
oleum73613322oleum
plea66830602plea
pleb86123812pleb
pled75231432pled
plew97222812plew
plex137321372plex
plum85122102plum
poem86225772poem
rem56150042_rem
seem65438562seem
slam67737972slam
sled55334372sled
slew76228232slew
slim66631962slim
slum65430512slum
stem610628252stem
teem66132602teem
them97427042them
ulema7109712ulema
wyle105519382wyle_
wyled124611842wyled
wyles114615322wyles
xylems1833202xylems
yam87448992y_am
ye57650062y_e_
yea66445752y_ea
yeh97135772y_eh
yeld811423872yeld
yelk115320002yelk
yell76028322yell
yelp95621352yelp
yen66847382y_en
yep86638962y_ep
yes66250612y_es
yet66960692y_et
yew96436292y_ew
yom88043442y_om
yule75725142yule_
yules84521582yules
yum86132822y_um

Search took 1 second 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 Filter178691298720.0602978183.3
2DLD Change Limit298721150.73340753.1
3Display Results1151150.0333484.8
 (SQL Overall)1786911150.826216332.9
 
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.