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

396 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
biggie10381093(None) 
baggie102912191baggie
biggies113813521biggies
biggin103710601biggin
piggie103210771piggie
aggie73415012_aggie
baggier113611642baggier
baggies113814852baggies
bigeye1236642bigeye
bigger104315062bigger
bigging122815882bigging
biggins113410692biggins
biggish14247502biggish
biggity1435012biggity
biggy124413132bigg_y
bigtime1235752bigtime
bigwig1333342bigwig
bikie113915882bi_kie
bilge87618912bilg_e
bilgier10358532bilgier
billie85019172billie
binge85125512bing_e
birdie94013782birdie
birkie124110132birkie
boggier113711582boggier
boggle104511942boggle
bogie89524102b_ogie
boogie93515992boogie
bougie93613272bougie
budgie104310342budgie
buggier113611342buggier
buggies114613812buggies
doggie93910892doggie
giggle94313512giggle
higgle113811742higgle
jiggier16377822jiggier
jiggle153811992jiggle
loggie84011992loggie
luggie8318902luggie
miggle104012112miggle
moggie103210102moggie
niggle83612822niggle
piggier113510002piggier
piggies113813482piggies
piggin103111092piggin
veggie1136302veggie
wiggier12418862wiggier
wiggle113713012wiggle
abigail1044173abigail
aggies83515513_aggies
baddie104114033baddie
badge94819683badg_e
baggage1235633baggage
bagged114519903bagged
bagger104619203bagger
baggiest123011753baggiest
baggily1436043baggily
bagging123316983bagging
baggy125615683bagg_y
baglike14338943baglike
bagnio937523bagnio
bagpipe1453113bagpipe
bagwig1343083bagwig
bailie83818363bailie
bangle94018953bangle
barbie105018353barbie
barge85631023barg_e
bargee94624443bargee
barmie103816393barmie
bawtie113812143bawtie
beagle93612593beagle
beanie83618593beanie
begaze1838333begaze
beggar10328223beggar
begged115013803begged
begging123012653begging
begin85117353b_egin
begone9512133begone
begrim11118333begrim
begrime1276553begrime
beguile1056933beguile
beguine1068503beguine
beige81515373beig_e
beigne9148613beigne
belie75630383b_elie
bhistie1236763bhistie
biali73419073biali_
bialies93618413bialies
bialis83617163bialis
bible95119413bi_ble
biblike1536893biblike
bice86235553bi__ce
biddies113514493biddies
bide76041473bi__de
bidi78226563bi_di_
bidis86721143bi_dis
biface1358103biface
biffies152710853biffies
biffin14369103biffin
bifid11910703bi_fid
big67345713bi_g__
bigamies1337363bigamies
bigamy1436333bigamy
bigeyes1335653bigeyes
bigfeet1376153bigfeet
biggest1138143biggest
biggety1434433biggety
biggings13327473biggings
bight118728843bi_ght
bighted142810923bighted
bights124417963bights
bigly114814753bi_gly
bigos85020013bi_gos
bigoses1039073bigoses
bigot84828323bi_got
bigoted11258403bigoted
bigots95015133bigots
bigs76235013bi_g_s
bigwigs1443003bigwigs
bike106532593bi__ke
bikies124515163bi_kies
bilbies114712333bilbies
bile66147173bi__le
bilged105513183bilged
bilges94915633bilges
bilgiest11309883bilgiest
bilging114212683bilging
bilgy114713713bilg_y
billies93923503billies
binate8419773binate
bindi85617013bindi_
bindis94614583bindis
bindle94516263bindle
bine66650853bi__ne
binged105920823binged
binger94923443binger
binges93923123binges
binging113619383binging
bingo86020093bing_o
bingoes104013973bingoes
bingos95514793bingos
binit76431583bi_nit
biocide1237323biocide
biog76122313biog__
biogas94310913biogas
biogen9310253biogen
biogs85016113biog_s
biome94916993bi_ome
bionic103614573bionic
biopic123710673biopic
biotic103816603biotic
biotin83215823biotin
biotite9311033biotite
birdied11329433birdied
birdies104016213birdies
bireme10310143bireme
birkies133712433birkies
birle75023633bi_rle
birse74517403bi_rse
bise66437093bi__se
bisque17257843bisque
bistre83815023bistre
bite66546993bi__te
bitsier9379073bitsier
bittier94211663bittier
bize155926283bi__ze
bizone1738603bizone
blooie83913193blooie
boccie123311453boccie
bogged116019283bogged
boggiest123110933boggiest
bogging123615753bogging
boggish14238653boggish
boggled12409003boggled
boggler113910083boggler
boggles113411823boggles
boggy126116073bogg_y
bogies94724313b_ogies
bogle85821683b_ogle
bonnie85314853bonnie
boobie104015293boobie
boogied11379283boogied
boogies103719013boogies
bookie123516003bookie
bootie85421153bootie
bougies103715183bougies
braggier12136453braggier
bridge103711883bridg_e
brie65837903b__rie
brigade1136493brigade
brogue94211033brogue
budge94619873budg_e
budgies115312513budgies
bugeye1236533bugeye
bugged114318403bugged
bugger104418723bugger
buggiest123410363buggiest
bugging123515183bugging
buggy124613483bugg_y
bugle84721943b_ugle
bulge86419873bulg_e
bulgier103911213bulgier
bungee96319773bungee
bungle97116113bungle
buppie12288733buppie
burdie93615023burdie
burgee97120593burgee
burgle94815863burgle
burnie83715413burnie
bygone1256173bygone
byrnie11348573byrnie
civie103716353ci_vie
daggle93711903daggle
dickie133913113dickie
didie74120563di_die
digged104314653digged
digger94616083digger
digging113513703digging
digit73825273di_git
dinge75627303ding_e
dingier93513663dingier
dingies93618243dingies
dingle84317073dingle
dirge75117073dirg_e
doggier103810943doggier
doggies103613023doggies
dogie75222793_dogie
druggie10134073druggie
faggier12309843faggier
fidge104516053fidg_e
figged124013893figged
figging133313563figging
figure10258833figure
fizgig2032973fizgig
foggier12349913foggier
fogie96719003_fogie
fuggier12348963fuggier
gaggle93412623gaggle
gie47149543___gie
gigged104112293gigged
gigging93311773gigging
giggled114010073giggled
giggler101029883giggler
giggles103312933giggles
gigglier1154323gigglier
giggly12518703giggly
gighe10139733gi_ghe
gigue71210673gi_gue
gillie74816943gillie
gimmie11298173gimmie
girlie73711463girlie
goggle94511573goggle
guggle94110433guggle
haggis11209513haggis
haggle113511983haggle
hickie153812473hickie
higgled13339073higgled
higgler12369803higgler
higgles123911803higgles
hinge95323443hing_e
hippie132811243hippie
hoagie102310003hoagie
hogtie102711763hogtie
igg57116793_igg__
igged86012763_igged
igging93212063_igging
iggs66612673_igg_s
ignite71410573_ignite
indie63721463_indie
ingle64120433_ingle
jaggier16339183jaggier
jaggies163311083jaggies
jigged164412773jigged
jigger155313053jigger
jiggiest17277693jiggiest
jigging173011553jigging
jiggish19225943jiggish
jiggled17358843jiggled
jiggles164111433jiggles
jigglier1754093jigglier
jiggly18378713jiggly
jiggy17549143jigg_y
jiglike19105333jiglike
jimmie17376463jimmie
jingle143815223jingle
joggle154010353joggle
juggle154310283juggle
kiddie12359393kiddie
killie104114893killie
kiltie103210963kiltie
leggier9368233leggier
leggin8268593leggin
liege65314433lieg_e
ligase7259913ligase
ligate72519243ligate
lignin74911193lignin
lignite81310303lignite
ligule74010833ligule
ligure7279473ligure
lingier84113373lingier
loggia8457053loggia
loggier93811143loggier
luggies93011213luggies
magpie1139093magpie
midge95016543midg_e
migg85716793migg__
miggles113512033miggles
miggs96311373migg_s
mingier103815283mingier
mingle93518783mingle
misgive13339033misgive
mislie83219153mislie
moggies113111723moggies
muggee103612833muggee
muggier11288943muggier
naggier9309153naggier
nigger89713573nigger
niggled10319203niggled
niggler93610293niggler
niggles93512203niggles
nigglier1044843nigglier
niggly11418913niggly
nightie1179653nightie
nixie125114943ni_xie
noggin8288883noggin
noogie73612313noogie
pidgin10259813pidgin
pigged114214153pigged
piggiest12259663piggiest
pigging123614673pigging
piggins113010473piggins
piggish14227703piggish
piggy124011433pigg_y
piglike14157313piglike
pigmies122610993pigmies
pinkie124414273pinkie
pixie145415523pi_xie
puggier11309383puggier
raggee84217603raggee
raggies93214733raggies
raggle83712883raggle
reggae858953reggae
ridge75018663ridg_e
ridgier937883ridgier
ridgil8316823ridgil
rigged94517403rigged
rigger85616713rigger
rigging103016333rigging
rigid7913893ri_gid
ringgit946003ringgit
saggier92912063saggier
sickie123715743sickie
siege66718443sieg_e
sigil63515503si_gil
signee73617233signee
silkie103313403silkie
singe65731133sing_e
single74520603single
sniggle9316833sniggle
soggier93410883soggier
staggie9138463staggie
stogie7311313stogie
swaggie12135783swaggie
tinge64626613ting_e
tingle74319053tingle
tittie63213153tittie
toggle83810873toggle
twiggier1333073twiggier
veggies1237553veggies
vegie94614513_vegie
vigia94813273vi_gia
vigil94313003vi_gil
virgin1038083virgin
vogie95116663_vogie
vuggier12296813vuggier
waggle113612303waggle
wedgie11428353wedgie
widdie113410733widdie
wienie9229973wienie
wigged124413583wigged
wiggiest13269013wiggiest
wigging133413833wigging
wiggled13299603wiggled
wiggler123110763wiggler
wiggles123312463wiggles
wigglier1354453wigglier
wiggly14559683wiggly
wiggy134510733wigg_y
wiglike15125853wiglike
willie94116453willie
wingier113413273wingier
wriggle12316213wriggle
yippie13277843yippie
zigged184110193zigged
zigging193210533zigging
zingier17369483zingier

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.1401276364.3
2DLD Change Limit1127163965.70319764.3
3Display Results3963960.1402828.6
 (SQL Overall)1786913965.98329866.5
 
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.