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

87 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
egads7461092(None) 
egad64215411egad_
gads67843381_gads
ads49755732__ads
agars66120642agars
agas55938842aga_s
bads77048862_bads
beads85429502beads
beglads11127262beglads
brads85528292brads
cads76144522_cads
chads116122232chads
clads85722732clads
dads67442772_dads
deads75726912deads
degas75119162dega_s
duads76515342duads
dyads10549972dyads
ears46356592e_ars
eats47054872e_ats
eds46638922e__ds
egal55119432ega_l
egers65120372egers
eggars8398972eggars
eggs66516152eg_gs
egis56520652eg_is
egos55821652eg_os
elands74914772elands
elans55527752elans
elds56324852e_lds
emyds1144922emyds
ends56528522e_nds
eras45441502era_s
etas46432272eta_s
evade938182evade
evades1039022evades
exams14199082exams
eyas76427432eya_s
eyass84410782eyass
fads86939872_fads
gabs76740422_gabs
gad57556652_gad_
gadi66329722_gadi
gadis74825292_gadis
gaes56348032_gaes
gags66441062_gags
gals57946502_gals
gams76648882_gams
gaps76042972_gaps
gars55750742_gars
gas48870252_ga_s
gats56753442_gats
gauds75717722_gauds
gays87338022_gays
gears64628692gears
geds66730812_geds
gelds75118342gelds
gids65933732_gids
glads75620612glads
goads77022852goads
gods65438042_gods
grads75625752grads
heads95127112heads
hexads17468192hexads
jehads1735832jehads
lads56549132_lads
leads66028492leads
legals73412732legals
loads65323372loads
mads76845372_mads
meads85425322meads
megass9219442megass
menads95514382menads
ogams84112682ogams
pads76742952_pads
quads154515842quads
rads56046602_rads
reads64835272reads
regards94112562regards
roads66523622roads
scads85419962scads
shads95124482shads
tads57143942_tads
toads65621072toads
vegans103910852vegans
wads87343142_wads
woads94818442woads

Search took 2 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.0961861364.6
2DLD Change Limit53800871.70031647.1
3Display Results87870.0165437.5
 (SQL Overall)178691871.81298615.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.