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

377 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
noogie7361231(None) 
boogie93515991boogie
noogies82814581noogies
nookie103712431nookie
bogie89524102_bogie
boobie104015292boobie
boogied11379282boogied
boogies103719012boogies
bookie123516002bookie
bootie85421152bootie
bougie93613272bougie
cookie123716042cookie
coolie83821602coolie
cootie84223072cootie
doggie93910892doggie
dogie75222792_dogie
doobie94712682doobie
doolie73916832doolie
doozie163910642doozie
fogie96719002_fogie
foodie104413842foodie
footie94718132footie
goodie83613992goodie
goonie73615562goonie
hoagie102310002hoagie
hoodie105116132hoodie
hoolie93217772hoolie
kookie9389832kookie
loggie84011992loggie
looie55624242loo_ie
loonie64216452loonie
moggie103210102moggie
noggin8288882noggin
noodge8337572noodge
noodle73212542noodle
nookies113414962nookies
noose55624062noo_se
oorie53026362_oorie
roofie93411172roofie
rookie103613262rookie
roomie83013872roomie
stogie7311312stogie
toonie63617992toonie
vogie95116662_vogie
woodie103513612woodie
woolie93514482woolie
aggie73415013_aggie
anomie83215963anomie
apogee9312553apogee
baggie102912193baggie
biggie103810933biggie
blooie83913193blooie
boccie123311453boccie
boggier113711583boggier
boggle104511943boggle
bogies94724313_bogies
bogle85821683_bogle
bonnie85314853bonnie
boobies113718203boobies
boodies103721443boodies
boodle93215033boodle
booger94816553booger
boogey124711523boogey
boogy114518323boog_y
bookies133819403bookies
boomier113312183boomier
boonies93422483boonies
bootee84323023bootee
booties94124613booties
booze164718913boo_ze
boozier18349013boozier
bougies103715183bougies
brogue94211033brogue
brookie1347373brookie
budgie104310343budgie
coigne94612193coigne
collie83621993collie
cologne1039353cologne
commie124215523commie
conge85227593cong_e
congee96024463congee
congii957363congii
cooee74531023coo_ee
cookies133719273cookies
coolies93824963coolies
coombe124110093coombe
coontie9311413coontie
cooties93725733cooties
corbie103618203corbie
corgi8316083corgi_
corgis9314403corgis
corrie83621213corrie
cosie74728263_cosie
cowpie133511513cowpie
cowrie113814273cowrie
cozie163519123_cozie
dhootie1136453dhootie
dobie84920323_dobie
dodge86618123dodg_e
dodgier10388243dodgier
doge66233803_dog_e
doggier103810943doggier
doggies103613023doggies
dogies85022253_dogies
dongle83612493dongle
donsie7613643donsie
doobies103915673doobies
doodies94218773doodies
doodle83212853doodle
doolee73018953doolee
doolies83920713doolies
doomier103610123doomier
doozies173812723doozies
dormie9312623dormie
dowie94721143_dowie
doxie136017153_doxie
drogue8938333drogue
enologies10312973enologies
flooie93712153flooie
floosie10378933floosie
floozie19295453floozie
foggier12349913foggier
fogies104118063_fogies
folkie13369613folkie
foodies113416753foodies
footier104115103footier
footies103721543footies
footle93914383footle
footsie1047643footsie
foozle18369203foozle
forge95126943forg_e
forgive1436193forgive
gie47149543___gie
goalie7413153goalie
goggle94511573goggle
goodies93516993goodies
goofier11339313goofier
googlies1086763googlies
googly11417883googly
googol835843googol
gooier73516213goo_ier
goonier83612843goonier
goonies83618333goonies
goopier103910573goopier
goose65925903goo_se
goosier83512563goosier
gorge76423893gorg_e
gouge78220063goug_e
hoagies112811993hoagies
hogtie102711763hogtie
homie104622523_homie
hongi96715853hongi_
hongied12308163hongied
hongies112716473hongies
honkie133011663honkie
hoochie1537783hoochie
hoodier113812973hoodier
hoodies113419833hoodies
hookier143811673hookier
hookies144017443hookies
hoopoe11911233hoopoe
hootier104915343hootier
hottie92514363hottie
howdie13349723howdie
joggle154010353joggle
kookier10398283kookier
koppie14277873koppie
lodge76520083lodg_e
loge56837193_log_e
loggia8457053loggia
loggier93811143loggier
logia68116603_logia
logic88217833_logic
logier75015733_logier
login66025003_login
logoi69715943logoi_
longe66626463long_e
longies82916553longies
loobies93814103loobies
looies65025833loo_ies
loonier73312673loonier
loonies73919543loonies
loopier93711193loopier
loose56627683loo_se
louie55023513_louie
luggie8318903luggie
moggies113111723moggies
mollie83517103mollie
mongoe94214983mongoe
monie75631653_monie
moodier103212203moodier
moonier93714103moonier
moorier93113073moorier
moose76327193moo_se
morgue938113morgue
movie105319133_movie
moxie144018123_moxie
naggier9309153naggier
nannie63713223nannie
naoi46024633nao_i_
nappie104112263nappie
nargile847653nargile
nellie63614813nellie
neogene847553neogene
neologic1149233neologic
neologies10411713neologies
neologize1946963neologize
newbie11135413newbie
newie81813483n_ewie
newsie9138213newsie
niggle83612823niggle
niobic1037233niobic
niobite937943niobite
nixie125114943n_ixie
nobbier11309163nobbier
nobble103814313nobble
noble74420993n_oble
nobodies1137293nobodies
noddies93512043noddies
noddle83211363noddle
node513036883n_o_de
nodi56626743n_odi_
nodose738883nodose
nodule7309803nodule
noesis6311443noesis
noetic8514043noetic
nog46847313n_og__
nogg65115943n_og_g
nogged95716333nogged
nogging103612723nogging
noggins9288453noggins
noggs75811183n_oggs
nogs56534613n_og_s
noil46133243n_o_il
noir46722433n_o_ir
noise55723733n_oise
noisier759453noisier
nome66038423n_o_me
nomoi76012533nomoi_
nonage7313683nonage
nonce75719823n_once
none45743173n_o_ne
nongame1038173nongame
nongay10169153nongay
nonlife1038553nonlife
nonuse63212253nonuse
noo37154043noo___
noodged10295923noodged
noodges9317703noodges
noodging11185693noodging
noodled9339923noodled
noodles83513193noodles
nook85728493noo__k
nooklike1134873nooklike
nooks95420393noo_ks
nooky124814813noo_ky
noon47134623noo__n
nooning83014853nooning
noons54125283noo_ns
noontide986133noontide
noontime1095383noontime
noosed75018013noosed
nooser65517823nooser
nooses65623643nooses
noosing83315053noosing
nope65934193n_o_pe
nordic939473nordic
nori47133143n_ori_
noria55722183n_oria
noris54928273n_oris
norite63221133norite
nose46739363n_o_se
nosier63716323n_osier
notate63217863notate
note46239963n_o_te
notice8313443notice
nougat74712653nougat
nought104713963nought
novae85913123n_ovae
novice1138433novice
nowise9511073nowise
noyade1036423noyade
nozzle14236633nozzle
nudge74616423nudg_e
nudie65118673n_udie
ogee57629883__ogee
ogive9379093__ogive
ogle56325053__ogle
ogre56320743__ogre
oldie6415473_oldie
ologies8615023ologies
oolite63319603_oolite
oologic1049423oologic
oologies9312993oologies
ootid61416693_ootid
ooze136420603_oo_ze
oozier153610253_oozier
orgic8311823_orgic
orgies72316093_orgies
ourie54027293_ourie
piggie103210773piggie
podgier11338723podgier
pogies94123543_pogies
pommie123710503pommie
pongee94920193pongee
pongid104111583pongid
poodle93112043poodle
poori74816233poori_
pooris83916843pooris
poove104514303poo_ve
popsie103013053popsie
porgies103017003porgies
postie84123963postie
potpie103412423potpie
potsie83916023potsie
roadie72813803roadie
rogue66417533_rogue
roofies103014413roofies
rookier114012383rookier
rookies113917103rookies
roomier93812243roomier
roomies93017243roomies
roose56127093roo_se
rootier74915393rootier
rootle63214453rootle
rouge65423443roug_e
shogi95013993shogi_
shogis103810923shogis
snoopier10177273snoopier
snootier8278373snootier
snooze15439983snoo_ze
snoozier17185183snoozier
snoozle16305903snoozle
softie93312473softie
soggier93410883soggier
soigne74310033soigne
sonsie6614853sonsie
soothe94214843soothe
sootier73916603sootier
sortie63621983sortie
stogies8413693stogies
stooge73811663stoog_e
stoolie739713stoolie
togae67020113_togae
toggle83810873toggle
togue64816303_togue
tongue7410093tongue
toonies73719883toonies
tootle62613813tootle
tootsie737123tootsie
toughie1187593toughie
towie85821873_towie
townie93312303townie
twoonie1034423twoonie
veggie1136303veggie
vegie94614513_vegie
vogue95613043_vogue
wedgie11428353wedgie
whoopie15295913whoopie
wodge107212923wodg_e
woodier113912063woodier
woodies113517153woodies
woolier103612353woolier
woolies104117363woolies
woozier19347323woozier
yogee9518063_yogee
yogi86120423_yogi_
yogic116114933_yogic
yogin98317743_yogin
yogis95617743_yogis
yowie114616453_yowie
zombie1937313zombie
zooglea1733373zooglea
zooid15312103zoo_id
zooier153411233zoo_ier
zootier163611173zootier
zowie174313843_zowie

Search took 7 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.1561145455.1
2DLD Change Limit1127163776.42017557.0
3Display Results3773770.1262992.1
 (SQL Overall)1786913776.70226662.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.