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

367 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
jiggle15381199(None) 
giggle94313511giggle
higgle113811741higgle
jiggled17358841jiggled
jiggles164111431jiggles
jiggly18378711jiggly
jingle143815221jingle
joggle154010351joggle
juggle154310281juggle
miggle104012111miggle
niggle83612821niggle
wiggle113713011wiggle
biggie103810932biggie
boggle104511942boggle
daggle93711902daggle
dingle84317072dingle
gaggle93412622gaggle
giggled114010072giggled
giggler101029882giggler
giggles103312932giggles
giggly12518702giggly
goggle94511572goggle
guggle94110432guggle
haggle113511982haggle
higgled13339072higgled
higgler12369802higgler
higgles123911802higgles
ingle64120432_ingle
jangle144416292jangle
jigged164412772jigged
jigger155313052jigger
jiggier16377822jiggier
jigglier1754092jigglier
jiggy17549142jigg_y
jingled164111062jingled
jingler154311082jingler
jingles153816382jingles
jingly174111932jingly
joggled17398432joggled
joggler16398832joggler
joggles164410412joggles
juggled17348652juggled
juggler16418872juggler
juggles164510842juggles
jungle144012652jungle
ligule74010832ligule
miggles113512032miggles
mingle93518782mingle
niggled10319202niggled
niggler93610292niggler
niggles93512202niggles
niggly11418912niggly
piggie103210772piggie
raggle83712882raggle
single74520602single
sniggle9316832sniggle
tingle74319052tingle
toggle83810872toggle
waggle113612302waggle
wiggled13299602wiggled
wiggler123110762wiggler
wiggles123312462wiggles
wiggly14559682wiggly
wriggle12316212wriggle
aggie73415013_aggie
agile65122263_agile
aiglet74224193ai_glet
aisle55223193ai_sle
angle64528873_angle
argle65421563_argle
argyle1066063argyle
atingle848253atingle
baggie102912193baggie
bangle94018953bangle
beagle93612593beagle
bible95119413bi_ble
bigeye1236643bigeye
bigger104315063bigger
biggies113813523biggies
biggin103710603biggin
biggy124413133bigg_y
bigly114814753bi_gly
bile66147173bi__le
bilge87618913bilg_e
bindle94516263bindle
binge85125513bing_e
birle75023633bi_rle
boggled12409003boggled
boggler113910083boggler
boggles113411823boggles
bogle85821683_bogle
bugle84721943_bugle
bungle97116113bungle
burgle94815863burgle
cicale10314503cicale
circle1039703circle
citole8311503citole
cringle103010353cringle
daggled11329463daggled
daggles103611913daggles
dangle84119303dangle
dibble114013843dibble
diddle94915213diddle
digged104314653digged
digger94616083digger
dimple113512793dimple
dindle84417223dindle
dinge75627303ding_e
dingles93818323dingles
dipole91112853dipole
dirge75117073dirg_e
doggie93910893doggie
dongle83612493dongle
draggle1056103draggle
eagle64219483_eagle
fickle153912973fickle
fiddle113613383fiddle
fidge104516053fidg_e
figged124013893figged
figure10258833figure
file75446643fi__le
fille84327403fi_lle
fimble133611743fimble
finagle11238313finagle
finale94116763finale
fipple13329063fipple
fizzle17369713fizzle
fugle94915543_fugle
gaggled11359913gaggled
gaggles103512593gaggles
gale56347323__gale
gargle84215463gargle
gigged104112293gigged
gigglers11297393gigglers
gigglier1154323gigglier
gighe10139733gi_ghe
giglet83920273gi_glet
gigolo836533gigolo
gigue71210673gi_gue
girdle82110463girdle
goggled11348953goggled
goggler10379323goggler
goggles103510793goggles
goggly12337053goggly
guggled11338563guggled
guggles103410543guggles
gurgle83912473gurgle
haggled13359283haggled
haggler12328933haggler
haggles123312483haggles
higglers13297223higglers
highly1636823highly
hinge95323443hing_e
hirple11158973hirple
hirsle9159573hirsle
idle55423763_i_dle
igg57116793_igg__
igged86012763_igged
iggs66612673_igg_s
iglu510814783_i_glu
ingles74420873_ingles
inkle94515833_inkle
isle45121703_i_sle
istle52214713_istle
ixtle12168013_ixtle
jagg136115313jagg__
jagged164115353jagged
jagger154016003jagger
jaggier16339183jaggier
jaggies163311083jaggies
jaggs148111493jagg_s
jaggy175913143jagg_y
jangled164111563jangled
jangler153811833jangler
jangles154015683jangles
jangly174310603jangly
jaygee1759463jaygee
jibe136323383ji__be
jig115633513ji_g__
jiggered1834203jiggered
jiggers164010173jiggers
jiggiest17277693jiggiest
jigging173011553jigging
jiggish19225943jiggish
jiggliest1854183jiggliest
jiggling18226363jiggling
jiglike19105333jiglike
jigs126524763ji_g_s
jigsaw1742493jigsaw
jill116430263ji__ll
jills125122823ji_lls
jilt115839423ji__lt
jimmie17376463jimmie
jimply20397483jimply
jingal1498583jingal
jingall1566163jingall
jingals1588063jingals
jingko18505373jingko
jinglers16408753jinglers
jinglier1655223jinglier
jingo134615213jing_o
jingoes153811433jingoes
jinnee13411573jinnee
jive146123593ji__ve
jogged166015923jogged
jogger154713163jogger
jogglers17356883jogglers
jole117233823j__ole
jostle13319863jostle
joule124918203j_oule
jubile152910253jubile
judge144714153judg_e
jugal135612403jugal_
jugate14379463jugate
jugged163813933jugged
jugglers17366523jugglers
jugglery20303813jugglery
jugula1434983jugula
jumble174012653jumble
jungled16349643jungled
jungles154112543jungles
jungly17407693jungly
justle133211583justle
kibble143910953kibble
kindle114414233kindle
kinglet123114043kinglet
kingly143511303kingly
kirtle10309473kirtle
kittle104012173kittle
liable81415813liable
liege65314433lieg_e
ligase7259913ligase
ligate72519243ligate
ligula7359673ligula
ligulae8308753ligulae
ligules82210913ligules
ligure7279473ligure
lisle53916723li_sle
little63312163little
loggie84011993loggie
luggie8318903luggie
mangle93921323mangle
mickle143715133mickle
middle103414983middle
midge95016543midg_e
migg85716793migg__
miggs96311373migg_s
mile66352563mi__le
mille75029133mi_lle
mingled113612733mingled
mingler104213833mingler
mingles103719003mingles
mizzle16279993mizzle
moggie103210103moggie
muggee103612833muggee
nibble103713283nibble
nickle123814483nickle
nigger89713573nigger
nigglers10307243nigglers
nigglier1044843nigglier
nimble103412933nimble
nipple103410373nipple
ogle56325053__ogle
pickle144215653pickle
piddle103514913piddle
piffle14418233piffle
pigged114214153pigged
piggier113510003piggier
piggies113813483piggies
piggin103111093piggin
piggy124011433pigg_y
piglet93420923pi_glet
pile65649693pi__le
pilule8411123pilule
pimple123512963pimple
pinole83218783pinole
pintle83818263pintle
pizzle16279493pizzle
pungle94413573pungle
raggee84217603raggee
raggles93813283raggles
regale74821453regale
reggae858953reggae
rejuggle17122553rejuggle
riddle83915713riddle
ridge75018663ridg_e
ridgel8399963ridgel
riffle124210233riffle
rifle85518333ri_fle
rigged94517403rigged
rigger85616713rigger
rile45650533ri__le
rille55728733ri_lle
rimple103814583rimple
ringlet82818173ringlet
ripple103413913ripple
shingle117711273shingle
sickle124418323sickle
sidle65124033si_dle
siege66718443sieg_e
sigil63515503sigil_
sigils73912363sigils
sigla64515203si_gla
signee73617233signee
simile83115623simile
simple104315173simple
singe65731133sing_e
singled93914683singled
singles83520433singles
singlet84120113singlet
singly104015853singly
sizzle14309613sizzle
smuggle11265013smuggle
sniggled11275743sniggled
sniggler10396113sniggler
sniggles10307313sniggles
snuggle9275713snuggle
squiggle1943173squiggle
swingle113510563swingle
tangle74019953tangle
tickle124616743tickle
tile45451443ti__le
tinge64626613ting_e
tingled93712793tingled
tingler83613323tingler
tingles83818313tingles
tingly103815963tingly
tinkle103714453tinkle
tipple103411913tipple
title54721073ti_tle
tittle63613323tittle
toggled10428653toggled
toggler9399193toggler
toggles93710973toggles
vagile10310543vagile
veggie1136303veggie
viable111613773viable
vigil94313003vigil_
vigils104210193vigils
vile76139803vi__le
virgule1144283virgule
virile9313433virile
vittle94711753vittle
waggled13389363waggled
waggles123812003waggles
waggly14347293waggly
wangle103817503wangle
widdle113814843widdle
wigged124413583wigged
wiggier12418863wiggier
wigglers13257203wigglers
wigglier1354453wigglier
wiggy134510733wigg_y
wiglet105519153wi_glet
wile75944373wi__le
wimble133211913wimble
wimple133611363wimple
windle104617953windle
winglet113115983winglet
winkle133812833winkle
wintle94014603wintle
wriggled14284663wriggled
wriggler13295263wriggler
wriggles13286263wriggles
wriggly15324893wriggly
zigged184110193zigged
zizzle13247313zizzle

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163674.89023050.3
3Display Results3673670.1262912.7
 (SQL Overall)1786913675.15634656.9
 
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.