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

106 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
ileus5461689(None) 
ileum74512821ileum
lieus56218481lieus
pileus84514941pileus
alecs76620732alecs
alefs87319662alefs
ales47067102ale_s
biles75542142bile_s
blebs96416152blebs
bless75917812bless
blets75324942blets
blues75127042blues
clefs106616242clefs
clews105516332clews
clues74623032clues
coleus86818272coleus
emeus76913332emeus
feus75830752_feus
filers94623722filers
files85441272file_s
filets94718952filets
fleas86423662fleas
flees85828752flees
flews115316442flews
fleys117015602fleys
flues84626922flues
flus75626542fl_us
gleds75417892gleds
glees65027592glees
glens66519852glens
gleys96514852gleys
glues65125682glues
hilus84817642hil_us
ices66129642ice_s
ictus7249692ictus
ideas65919012ideas
ides57734232ide_s
idlers74012812idlers
idles66720122idle_s
iglus6609932iglus
ilea45931462ile_a
ileac75814172ileac
ileal56118082ileal
ileuses738672ileuses
ilex115822032ile_x
ilexes134510252ilexes
ilium74614172ilium
ilks87218572il_ks
ills47030422il_ls
incus73315052incus
inlets63915572inlets
ires45639282ire_s
isles54220562isle_s
islets64513082islets
items7499612items
leas45954182_leas
lees45455882_lees
legs56133692_legs
leis45739602_leis
leks85427602_leks
lens46146492_lens
les35663072_le_s
less45635102_less
lets47147942_lets
leu36047402_leu_
leud57223422_leud
leuds66214812_leuds
leys76430182_leys
liens56525502liens
liers55130402liers
lies46454192lie_s
lieu46534362lieu_
lues45943552_lues
milers84625162milers
miles74645072mile_s
milieus939802milieus
oilers64721192oilers
oleos55419682oleos
oles46453472ole_s
oleum73613322oleum
oleums8358782oleums
pilaus84114132pilaus
pileous9510522pileous
piles74742612pile_s
pileum10399512pileum
pileup10437922pileup
pileups11365432pileups
pilous84717752pilous
pilus75921062pil_us
pleas75627032pleas
plebs95814582plebs
plews105415352plews
plexus15377282plexus
plus66324832pl_us
riles55343642rile_s
silenus7369692silenus
sleds64418852sleds
slews86220352slews
slues54527172slues
soleus64615612soleus
tilers63523492tilers
tiles55542102tile_s
ulus45622562ul_us
villus93611222villus
wiles85437872wile_s
ylems1039262ylems

Search took 3 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 Filter178691538000.1401276364.3
2DLD Change Limit538001062.03326463.4
3Display Results1061060.0462304.3
 (SQL Overall)1786911062.21980527.7
 
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.