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

260 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
jiggling1822636(None) 
giggling10227041giggling
higgling14217161higgling
jigging173011551jigg_ing
jingling17188571jingling
joggling18215571joggling
juggling18225601juggling
niggling11227441niggling
wiggling14217291wiggling
bigging122815882bigg_ing
boggling13257162boggling
daggling12237062daggling
digging113513702digg_ing
figging133313562figg_ing
gaggling10217462gaggling
gigging93311772gigg_ing
goggling10246282goggling
guggling10236352guggling
haggling14227272haggling
igging93212072_igg_ing
jagging173311992jagg_ing
jangling17249622jangling
jiggering1934292jiggering
jigglier1754092jigglier
jogging173211232jogg_ing
jugging172910722jugg_ing
jugglings19212722jugglings
mingling122010932mingling
nigglings12213722nigglings
pigging123614672pigg_ing
ridgling11258202ridgling
rigging103016332rigg_ing
singling101913002singling
sniggling1244412sniggling
tingling102210802tingling
toggling11206482toggling
waggling14197062waggling
wigging133413832wigg_ing
wriggling1533812wriggling
zigging193210532zigg_ing
ailing74331013ai__ling
angeling102811733angeling
angling92816043_angling
argling92812733_argling
bagging123316983bagg_ing
begging123012653begg_ing
biggin103710603bigg_in_
biggings13327473bigg_ings
biggins113410693bigg_ins
bighting15269453bighting
bilging114212683bilg_ing
billing103823853bi_lling
bingeing12237643bingeing
binging113619383bing_ing
birling104317053bi_rling
bogging123615753bogg_ing
bugging123515183bugg_ing
bugling113615343_bugling
bungling12269543bungling
burgling12239303burgling
cageling12310843cageling
circling1338423circling
cogging123513713cogg_ing
dangling112611233dangling
dialing94318173di_aling
dialling10310783dialling
dibbling14247333dibbling
diddling12228733diddling
diggings12316623digg_ings
dighting142510843dighting
dimpling14199023dimpling
dindling112411163dindling
dinging103618613ding_ing
dirling93316073di_rling
dogging113312693dogg_ing
draggling1354613draggling
eagling91113603_eagling
egging93210983_egg_ing
fagging133714763fagg_ing
fiddling14217863fiddling
fidging133910503fidg_ing
fighting162710083fighting
figuline1256033figuline
figuring1336283figuring
filing103823763fi__ling
filling113520803fi_lling
finagling1434703finagling
fizzling20264993fizzling
fogging133513733fogg_ing
frigging14268953frigg_ing
fugging133912913fugg_ing
fugling124212513_fugling
gagging93013523gagg_ing
gangling112411403gangling
gargling11239203gargling
gigglier1154323gigglier
gigglingly1542003gigglingly
gilling93520383gi_lling
girdling1146823girdling
gurgling11267323gurgling
hagging133114683hagg_ing
highting16259723highting
hilling113821773hi_lling
hinging123917103hing_ing
hireling121210993hireling
hirpling1467223hirpling
hirsling1277543hirsling
hogging133112803hogg_ing
hugging132710633hugg_ing
idling8912883_i_dling
ingoing9311023_ingoing
inkling122911303_inkling
isling71213883_i_sling
jailing153415843j_ailing
jelling153516613j_elling
jeweling1935483jeweling
jibbing19338063ji_bbing
jibing16379623ji__bing
jiggier16377823jigg_ier
jiggish19225943jigg_ish
jiggle153811993jiggl__e
jiggled17358843jiggl_ed
jiggles164111433jiggl_es
jiggliest1854183jiggliest
jiggly18378713jiggl__y
jiglike19105333ji_glike
jigsawing2141933jigsawing
jilting153211743ji_lting
jimmying2342383jimmying
jinglier1655233jinglier
jinking193613543ji_nking
jinxing22306503ji_nxing
jiving173711603ji__ving
joggings18264633jogg_ings
jostling16207123jostling
judging17337933judg_ing
jumbling20217233jumbling
justling16207253justling
kegging14328293kegg_ing
kegling13309363_kegling
kibbling17225703kibbling
killing123118723ki_lling
kindling14229623kindling
kinging133115033king_ing
kitling123313573ki_tling
kittling1336063kittling
lagging103316733lagg_ing
legging103912643legg_ing
libeling1139873libeling
ligating102212283ligating
lighting132811833lighting
logging103316803logg_ing
lugging104114353lugg_ing
mangling122312623mangling
miauling1137343miauling
middling13249333middling
milling103223683mi_lling
mizzling19255443mizzling
mogging123311493mogg_ing
mugging122711793mugg_ing
nagging102613043nagg_ing
nibbling13256503nibbling
nickling15278703nickling
nigglier1044843nigglier
nigglingly1642313nigglingly
nighing123410063ni_ghing
nilling83619563ni_lling
nogging103612723nogg_ing
ogling83211883__ogling
oiling74925313oi__ling
pegging122811133pegg_ing
pickling17239203pickling
piddling13208943piddling
piffling1745133piffling
piggin103111093pigg_in_
piggins113010473pigg_ins
piling95025593pi__ling
pilling103722563pi_lling
pindling122110983pindling
pinging113419553ping_ing
prigging13299093prigg_ing
pugging122912543pugg_ing
pungling12228663pungling
ragging103516683ragg_ing
regaling10315363regaling
rejigging1933923rejigg_ing
rejuggling2041873rejuggling
riddling11249433riddling
ridgeling12155253ridgeling
ridging104112983ridg_ing
ridglings12214173ridglings
riesling939013riesling
riffling1556113riffling
rifling112815013ri_fling
riggings11327133rigg_ings
righting132610853righting
riling74227973ri__ling
rilling84023623ri_lling
rimpling13219663rimpling
ringing93521283ring_ing
rippling13197573rippling
rivaling1239913rivaling
rugging102512763rugg_ing
sagging103116103sagg_ing
shingling14136953shingling
sibling10814423si_bling
sickling152910333sickling
sideling101012173sideling
sidling9915423si_dling
sieging92613203sieg_ing
sighing123311663si_ghing
sighting133110863sighting
signaling1136563signaling
signing92713963si_gning
singeing10209933singeing
singing93221423sing_ing
sizzling17225783sizzling
smuggling1433243smuggling
snuggling1243473snuggling
squiggling2241883squiggling
swigging14337223swigg_ing
swingling14156203swingling
tagging103014913tagg_ing
tangling101712533tangling
tickling15309433tickling
tiling73426553ti__ling
tilling83522773ti_lling
tingeing10198533tingeing
tinging93619443ting_ing
tinkling13239233tinkling
tippling13196703tippling
tirling83315733ti_rling
titling83715793ti_tling
togging103512743togg_ing
trigging11299583trigg_ing
tugging102611233tugg_ing
twigging14305673twigg_ing
vegging13308873vegg_ing
vialing113614163vi_aling
vialling1237223vialling
vittling1236143vittling
wagging133313353wagg_ing
wangling132310993wangling
widdling14228733widdling
wiggings14316173wigg_ings
wigglier1354453wigglier
wildling13248083wildling
wiling103024293wi__ling
willing113821613wi_lling
wimbling16186543wimbling
wimpling16207483wimpling
windling132212263windling
wingding1436453wingding
winging123718713wing_ing
winkling16298293winkling
wintling12249923wintling
witling113215813wi_tling
zagging193210453zagg_ing
zinging183513943zing_ing
zizzling16233923zizzling

Search took 10 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622609.01616211.4
3Display Results2602600.1102363.6
 (SQL Overall)1786912609.28219251.3
 
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.