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

337 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
bobbin9341072(None) 
bobbing113113191bobbing
bobbins103410341bobbins
dobbin11339511dobbin
robbin103611171robbin
bibbing11299602bibbing
blobbing12246922blobbing
bobbed104315832bobbed
bobber95016742bobber
bobbies103714562bobbies
bobbinet1157902bobbinet
bobble94115142bobble
bobbling12238642bobbling
bobby114814652bobb_y
bodkin1338922bodkin
boffin14359052boffin
bombing143211382bombing
bonbon10310072bonbon
boobie104015292boobie
boobing123613912boobing
boudin9412372boudin
bowfin14338352bowfin
dobbins12379532dobbins
dubbin11329252dubbin
fobbing153410272fobbing
gobbing132910702gobbing
goblin939502goblin
hobbing152811122hobbing
hobbit132810522hobbit
jobbing19279012jobbing
lobbing123110912lobbing
mobbing14299702mobbing
nubbin10308282nubbin
rabbin103112292rabbin
robbing123313212robbing
robbins112811062robbins
robin74820272ro_bin
sobbing127612882sobbing
babbitt1038033babbitt
babble94017113babble
babbling12228693babbling
baboon103613913baboon
babying1537963babying
bambini1336573bambini
bambino1336473bambino
barbie105018353barbie
barbing123716993barbing
basin75026923b_asin
beduin939713beduin
begin85117353b_egin
benzin1738933benzin
berlin83116373berlin
bibb75819193bibb__
bibbed104712343bibbed
bibber94613573bibber
bibbs84911573bibb_s
biffin14369103biffin
biggin103710603biggin
bin56658633___bin
biotin83215823biotin
blabbing12266723blabbing
blain75421793b_lain
blebbing12265673blebbing
blin67228173__blin
blobbed11366563blobbed
blubbing12257013blubbing
boating103721303boating
bob76755663bo_b__
bobbers103614283bobbers
bobbery13438343bobbery
bobbinets1243073bobbinets
bobbled113811833bobbled
bobbles104514913bobbles
bobcat12411253bobcat
bobolink1644493bobolink
bobs86340643bo_b_s
bobtail1146553bobtail
bocci113512713bocci_
boccia12338793boccia
boccie123311453boccie
boccis123911133boccis
boding104320063bo_ding
bodkins1438313bodkins
bodying1438973bodying
boffing16339983boffing
boffins15329073boffins
bogan87519003bo_gan
bogbean1244643bogbean
bogging123615753bogging
bogie89524103bo_gie
boil66335183bo__il
boiling103819673boiling
boing84725553bo__ing
boink115516333bo__ink
bolling103820883bolling
bollix1538053bollix
bolson8410683bolson
bolting104416763bolting
bomb106927423bomb__
bombax1935753bombax
bombe115519313bomb_e
bombed134113873bombed
bomber125014653bomber
bombes124916823bombes
bombesin1444233bombesin
bombings15266493bombings
bombs115818823bomb_s
bombyx2232693bombyx
bonbons1139333bonbons
bonding113318433bonding
bonging113316373bonging
boning94223293bo_ning
bonking144116373bonking
bonnie85314853bonnie
boob85932583boob__
boobed114514873boobed
boobies113718203boobies
boobird1235233boobird
boobish14338943boobish
booboo1039463booboo
boobs96221993boob_s
booby125319513boob_y
boogie93515993boogie
booing94521643bo_oing
bookie123516003bookie
booking143618383booking
booming123716223booming
boomkin1545363boomkin
boon67142173bo__on
bootie85421153bootie
booting103821363booting
boozing194012163boozing
bopping143512033bopping
boreen8314313boreen
boric98024223bo_ric
boring94724873bo_ring
borking144716173borking
born67338413bo__rn
boron76727143bo_ron
boson76019733bo_son
bossing103714603bossing
boston8513043boston
bosun75113593bo_sun
botulin947653botulin
boubou1038423boubou
boudins10311313boudins
bougie93613273bougie
bourbon1135813bourbon
bourn75518483bo_urn
boursin938283boursin
bousing103718043bousing
bouton8311533bouton
bovid111011623bo_vid
bovine11712433bo_vine
bowfins15267703bowfins
bowing124723063bo_wing
bowline123613113bowline
bowling133916493bowling
bowman13129853bowman
bowmen1399853bowmen
bowsing134012503bowsing
boxing163915153bo_xing
brain76229383b_rain
bribing123111043bribing
brin67038193__brin
bromin102615693bromin
brucin1049133brucin
bruin75818333b_ruin
bubba84311793bubb_a
bubbas94110703bubbas
bubbies103913513bubbies
bubble94016593bubble
bubbling12248223bubbling
bubbly124110353bubbly
bubby115013923bubb_y
bulbil10389573bulbil
bumkin14308083bumkin
burin75626063b_urin
buskin123811493buskin
cabbie122913343cabbie
cabbing143613153cabbing
cabin94820933_cabin
coalbin1137523coalbin
cobb106421993cobb__
cobber124116843cobber
cobbier133410163cobbier
cobble123615263cobble
cobbling15248803cobbling
cobbs115013983cobb_s
cobby145516403cobb_y
cobia94117503co_bia
cocain101315013cocain
cochin131313203cochin
codein94916713codein
codlin94516433codlin
coffin14339813coffin
coin66645353co__in
cojoin1539493cojoin
colin76231693co_lin
combine133014713combine
combing143714723combing
conin76232723co_nin
corban10314693corban
corbie103618203corbie
corbina111911443corbina
cortin82423143cortin
cousin8517153cousin
covin105621123co_vin
cowbind1536613cowbind
dabbing133511233dabbing
dibbing133110883dibbing
dobber114015413dobber
dobbies124113063dobbies
dobby136013623dobb_y
dobie84920323do_bie
doblon938013doblon
dobson936593dobson
domain9511323domain
doobie94712683doobie
dormin9312313dormin
dubbing133311213dubbing
dubbins12358803dubbins
ebbing1137063_ebbing
eosin55220923eo_sin
fibbing15339453fibbing
fibrin1138533fibrin
fobbed144112613fobbed
foin77231563fo__in
forbid123312433forbid
fubbing15409573fubbing
gabbing133512033gabbing
gibbing13339363gibbing
gibbon1135323gibbon
globin9309723globin
goban84414073go_ban
gobbed124613883gobbed
gobbet114214443gobbet
gobble113512983gobble
gobbling14257533gobbling
goblins1039243goblins
hobbed144114303hobbed
hobber134114633hobber
hobbies143813343hobbies
hobbits14317553hobbits
hobble133913433hobble
hobbling16227583hobbling
hobby155913723hobb_y
hoboing13309453hoboing
hoddin11369933hoddin
iodin64419343io_din
jabbing19319413jabbing
jibbing19338053jibbing
jobbed184212133jobbed
jobber173813353jobber
join116724833jo__in
kebbie1435803kebbie
kibbi13449263kibbi_
kibbis14398463kibbis
lobbed113114613lobbed
lobber104016593lobber
lobbied12337173lobbied
lobbies113612463lobbies
lobby125113913lobb_y
lobbying1633603lobbying
lobefin1244603lobefin
login66025003lo_gin
loin46838723lo__in
lomein8410203lomein
mobbed137112243mobbed
mobber123613463mobber
mobbish1635923mobbish
mobbism1535053mobbism
morbid112511463morbid
moulin8313283moulin
nabbing12299963nabbing
nibbing12339543nibbing
nobbier11309163nobbier
nobbily1436693nobbily
nobble103814313nobble
nobbling13228273nobbling
nobby125513453nobb_y
noggin8288883noggin
nubbins11268023nubbins
obi57127723_o_bi_
obia67923103_o_bia
obis66226833_o_bis
obit66837073_o_bit
obtain839183obtain
olein5316003_olein
opsin7613473_opsin
orbing93312353_orbing
orbit73622053_orbit
orcin72716573_orcin
orpin73415533_orpin
poplin10413483poplin
postin83521033postin
rabbi93113173rabbi_
rabbins112811343rabbins
rabbis102613153rabbis
rabbit102914553rabbit
ribbing123111943ribbing
ribbon1036533ribbon
robbed113415193robbed
robber103916533robber
robing93617993ro_bing
robins83617443ro_bins
rosin55325313ro_sin
rubbing123412273rubbing
sabbing123314743sabbing
sabin74924943_sabin
sobbed113516263sobbed
sobber104016583sobber
sobeit8315343sobeit
sorbic10310383sorbic
sorbing102815263sorbing
sozin14514523so_zin
stobbing13227243stobbing
subbing123915583subbing
swobbing16235173swobbing
tabbing123611913tabbing
tabbis102910853tabbis
tocsin8311003tocsin
tombing123310523tombing
toxin124716713to_xin
tubbing123510093tubbing
webbing1536123webbing
wobble133212313wobble
wobbling16246923wobbling
wobbly16347093wobbly
woodbin1354873woodbin
yabbie13308653yabbie
yobbo1237863yobb_o
yobbos1335963yobbos
yogin98317743yo_gin
zombi1838983zombi_
zombie1937313zombie
zombis1936273zombis

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 Limit1127163375.51620434.4
3Display Results3373370.1103063.6
 (SQL Overall)1786913375.76630990.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.