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

135 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
iggs6661267(None) 
eggs66516151eggs
gigs66631181gigs
igg57116791igg_
miggs96311371miggs
agas55938842agas
ages55844592ages
ags47551662_ags
bags76645502bags
begs75733832begs
biggy124413132biggy
bigos85020012bigos
bigs76235022bigs
biogs85016112biogs
bogs75742752bogs
bugs76035912bugs
cigs75625102cigs
cogs77340032cogs
dags66642602dags
digs66036052digs
dings76331402dings
dogs66440152dogs
dugs614832282dugs
egg56918672egg_
eggy96611852eggy
egis56520652egis
egos55821652egos
engs56121392engs
ergs55523812ergs
fags86939122fags
figs85332642figs
fogs87035002fogs
fugs85730692fugs
gags66441062gags
gas48870252_gas
gibs75529272gibs
gids65933742gids
gies55641422gies
gig56040752gig_
giga66720942giga
gigas75415582gigas
gins55543952gins
gips75632922gips
gits55744592gits
gos47155132_gos
hags86740842hags
highs125412522highs
hoggs107212462hoggs
hogs87139662hogs
hugs86129752hugs
ibis66519582ibis
ices66129642ices
ichs96214712ichs
ides57734232ides
ids47535472i_ds
ifs67124242i_fs
igged86012762igged
iglu510814782iglu
iglus6609932iglus
ilks87218572ilks
ills47030422ills
imps86221122imps
inks86926502inks
inns46920932inns
ins35945602i_ns
ions46737852ions
ires45639282ires
iris45732552iris
irks86220132irks
is27048212i__s
isms66213472isms
its35538832i_ts
iwis77117012iwis
jaggs148111492jaggs
jags126132792jags
jiggy17549142jiggy
jigs126524762jigs
jogs127129332jogs
jugs125525602jugs
kegs95824022kegs
kings105825562kings
lags56546222lags
legs56133692legs
lings67135772lings
logs57343112logs
lugs55233522lugs
mags75444532mags
megs75530632megs
migg85716802migg_
migs76935322migs
mogs75439332mogs
muggs94912322muggs
mugs76232042mugs
nags55436022nags
negs55727362negs
nighs95013612nighs
noggs75811182noggs
nogs56534612nogs
pegs75531762pegs
piggy124011432piggy
pigs76634222pigs
pings85830882pings
pugs76332772pugs
raggs75216472raggs
rags55448372rags
regs55436572regs
rigs55137592rigs
rings65029172rings
rugs56033682rugs
sags55948402sags
segs54933882segs
sighs95416742sighs
signs65516322signs
sings65532702sings
tags55545232tags
teggs74710742teggs
tegs56031492tegs
tings65329202tings
togs57242432togs
tugs56231672tugs
ughs85410972ughs
vigas94817882vigas
vigs85427272vigs
vuggs10579132vuggs
vugs87022872vugs
wags86140552wags
wiggy134510732wiggy
wigs84931252wigs
wings95727242wings
wogs86531402wogs
yags86632292yags
yeggs10608162yeggs
zags146826682zags
zigs145422792zigs
zings154620892zings

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 Filter178691298720.546327272.9
2DLD Change Limit298721351.53319486.0
3Display Results1351350.0602250.0
 (SQL Overall)1786911352.13983539.5
 
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.