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

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

170 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
sniggle931683(None) 
niggle83612821_niggle
sniggled11275741sniggled
sniggler10396111sniggler
sniggles10307311sniggles
snuggle9275711snuggle
giggle94313512_giggle
higgle113811742_higgle
jiggle153811992_jiggle
miggle104012112_miggle
niggled10319202_niggled
niggler93610292_niggler
niggles93512202_niggles
niggly11418912_niggly
shingle117711282shingle
single74520602s_ingle
smuggle11265012smuggle
sniffle13287652sniffle
snigger9328372snigger
snigglers11314592snigglers
sniglet83612412sni_glet
snuggled11234952snuggled
snuggles10306142snuggles
squiggle1943182squiggle
swingle113510562swingle
wiggle113713012_wiggle
wriggle12316212wriggle
angle64528873an__gle
anile54634463ani__le
anisole71010833anisole
atingle848253atingle
biggie103810933_biggie
boggle104511943_boggle
cringle103010353cringle
daggle93711903_daggle
dingle84317073_dingle
draggle1056103draggle
enisle63412093eni_sle
espiegle1142603espiegle
finagle11238313finagle
gaggle93412623_gaggle
giggled114010073_giggled
giggler101029883_giggler
giggles103312933_giggles
giggly12518703_giggly
goggle94511573_goggle
guggle94110433_guggle
haggle113511983_haggle
higgled13339073_higgled
higgler12369803_higgler
higgles123911803_higgles
ingle64120433__ingle
jiggled17358843_jiggled
jiggles164111433_jiggles
jiggly18378713_jiggly
jingle143815223_jingle
joggle154010353_joggle
juggle154310283_juggle
ligule74010833_ligule
miggles113512033_miggles
mingle93518783_mingle
nibble103713283_nibble
nickle123814483_nickle
nigger89713573_nigger
nigglers10307253_nigglers
nigglier1044843_nigglier
nimble103412943_nimble
nipple103410373_nipple
piggie103210773_piggie
raggle83712883_raggle
sanicle91210263sani_cle
senile63420213seni__le
shingled13358323shingled
shingler12268633shingler
shingles123111113shingles
shingly143210813shingly
sickle124418323s_ickle
sidle65124033s_i_dle
siege66718443s_ieg_e
sigil63515503s_igil_
sigils73912363s_igils
sigla64515203s_i_gla
signee73617233s_ignee
simile83115633s_imile
simple104315173s_imple
singable11159543singable
singe65731133s_ing_e
singled93914683s_ingled
singles83520433s_ingles
singlet84120113s_inglet
singly104015853s_ingly
sizzle14309613s_izzle
skiable1338883skiable
skiffle17225203skiffle
skittle1135533skittle
smidge10378483smidg_e
smile74823923smi__le
smuggled13254223smuggled
smuggler12244523smuggler
smuggles12225443smuggles
snaffle13216253snaffle
snagged104010673snagged
snaggier10136303snaggier
snaggy11488053snagg_y
snide64318723sni__de
snidely1136813snidely
sniffled15276443sniffled
sniffler14296833sniffler
sniffles14257723sniffles
sniffly16265643sniffly
sniggered1243443sniggered
sniggerer1142723sniggerer
sniggers10317093sniggers
sniggling1244413sniggling
sniglets9276813sni_glets
snipe75320573sni__pe
snivel9368853snivel_
sniveled1255463sniveled
sniveler1155253sniveler
snivels10336903snivels
snogged10417973snogged
snoozle16305913snoozle
snuffle13267833snuffle
snugged10408033snugged
snugger9318313snugger
snuggies10246363snuggies
snugly1055663sn_ugly
soigne74310033soi_gne
soignee8279133soignee
spangle1038403spangle
spicule11269933spicule
spiegel1034553spiegel
spile75230083spi__le
spindle103210093spindle
spinule9299993spinule
spittle937923spittle
squiggled2142453squiggled
squiggles2052993squiggles
squiggly2242503squiggly
staggie9138463staggie
stickle132410973stickle
stifle93611903sti_fle
stile54931573sti__le
stipple1146623stipple
stipule936723stipule
straggle10359133straggle
struggle10345053struggle
swaggie12135783swaggie
swigged13327183swigged
swigger12338453swigger
swindle11389183swindle
swinge105614383swing_e
swingled13337433swingled
swingles12319543swingles
swiple11379233swi_ple
swipple1444633swipple
swizzle1854103swizzle
tingle74319063_tingle
toggle83810873_toggle
unagile838283unagile
unmingle1145913unmingle
waggle113612303_waggle
wiggled13299603_wiggled
wiggler123110763_wiggler
wiggles123312463_wiggles
wiggly14559683_wiggly
wriggled14284663wriggled
wriggler13295263wriggler
wriggles13286263wriggles
wriggly15324893wriggly

Search took 8 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.390458182.1
2DLD Change Limit1340271706.57620381.2
3Display Results1701700.0632698.4
 (SQL Overall)1786911707.02925422.0
 
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.