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

262 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
bobbery1343835(None) 
bibbery13426541bibbery
bobber95016741bobber_
bobbers103614281bobbers
jobbery21366011jobbery
robbery14348281robbery
bibber94613572bibber_
bibbers103911352bibbers
blubbery14294782blubbery
bobbed104315832bobbe_d
bobby114814662bobb__y
bomber125014652bomber_
bombers134512592bombers
bootery1238982bootery
bowery146012112bo_wery
boxberry2242652boxberry
bribery14426482bribery
cobber124116842cobber_
cobbers134114752cobbers
dobber114015412dobber_
dobbers123513242dobbers
hobber134114632hobber_
hobbers143512342hobbers
jobber173813352jobber_
jobbers182911132jobbers
lobber104016602lobber_
lobbers113713942lobbers
mobber123613462mobber_
mobbers133610922mobbers
robber103916532robber_
robbers112814152robbers
rubbery14337592rubbery
slobbery15375662slobbery
snobbery15514292snobbery
sobber104016582sobber_
sobbers114114252sobbers
abbey125714933_abbe_y
ambery133811133_ambery
babbitry14273073babbitry
babbler104012823babbler_
babblers113510353babblers
babier103515573babier_
bakery155911003b_akery
barber104419323barber_
barberry1544863barberry
barbers114317503barbers
battery124911813battery
bayberry1842963bayberry
beanery1237563beanery
bebeeru1144263bebeeru
beery105220123__beery
bibbed104712343bibbe_d
bilberry1543283bilberry
bindery13459833bindery
blabber10418923blabber_
blabbers11308153blabbers
blobbed11366563blobbe_d
bloomery15335693bloomery
blubber10399293blubber_
blubbers11408143blubbers
boater84622093boater_
boaters93419233boaters
bobberies12107893bobberies
bobbies103714563bobbies
bobbin93410733bobb_in
bobbing113113193bobbing
bobbins103410343bobbins
bobble94115143bobb_le
bobbled113811833bobbled
bobbles104514913bobbles
bobstay1443983bobstay
bogbean1244643bogbean
bogey115220233bo_ge_y
boiler84319273boiler_
boilers93417063boilers
bolder94820933bolder_
bolero8412093bo_lero
bolter83920753bolter_
bolters94017803bolters
bombard1437333bombard
bombe115519313bombe__
bombed134113873bombe_d
bombes124916823bombe_s
bonder95324783bonder_
bonders104120663bonders
boner75133083bo_ner_
boners84825433bo_ners
boney105227313bo_ne_y
bonier84321993bonier_
bonkers134015303bonkers
bonzer175313673bonzer_
boobed114514873boobe_d
boobird1235233boobird
booby125319513boob__y
booger94816553booger_
boogers104514633boogers
boogey124711523booge_y
booker124719193booker_
bookers134016613bookers
boomer104618513boomer_
boomers114115913boomers
boozer174815963boozer_
boozers183912443boozers
bopper123813833bopper_
boppers133911923boppers
border94419973border_
borders104317533borders
borer75131273bo_rer_
borers85122683bo_rers
bosker123813653bosker_
botchery18366763botchery
bother115218063bother_
bothers124317753bothers
bouldery14295013bouldery
bower107328183bo_wer_
bowers115523703bo_wers
bowler114217313bowler_
bowlers123715783bowlers
bowyer14368923bowyer_
bowyers15438733bowyers
boxer145016523bo_xer_
boxers155013483bo_xers
boxier154311743boxier_
bravery15428133bravery
brewery15376953brewery
briber104714043briber_
bribers114111493bribers
briery114510773b_riery
broguery1443313broguery
broidery14356083broidery
bubbler103611783bubbler_
bubblers11448943bubblers
bubbly124110353bubb_ly
bubby115013933bubb__y
buggery14367933buggery
butlery12369423butlery
buttery124311193buttery
clobber13378163clobber_
clobbers14397513clobbers
cobbier133410163cobbier_
cobbler133311823cobbler_
cobblers14359593cobblers
cobby145516413cobb__y
comber125118503comber_
combers134516613combers
cookery164210393cookery
coopery143910273coopery
coppery16409393coppery
cowberry1843343cowberry
dabber114816963dabber_
dabbers123813213dabbers
daubery13396213daubery
dibber114614713dibber_
dibbers124013173dibbers
dobby136013633dobb__y
doddery13516853doddery
dodgery13627783dodgery
dogberry1542863dogberry
doggery13448263doggery
dowery134311663do_wery
dubber113814553dubber_
dubbers124011823dubbers
fabber134814113fabber_
fibber134811933fibber_
fibbers144510603fibbers
fobbed144112613fobbe_d
foolery1336693foolery
foppery17385623foppery
forgery14419303forgery
gabber114916603gabber_
gabbers124612833gabbers
gibber114112863gibber_
gibbers124710983gibbers
gobbed124613883gobbe_d
gobbet114214443gobbe_t
gobbets12327643gobbets
gobbler123310023gobbler_
gobblers13308343gobblers
goober93911743goober_
goobers10219623goobers
hobbed144114303hobbe_d
hobbler143710403hobbler_
hobblers15308513hobblers
hobby155913733hobb__y
hosiery13337183hosiery
jabber173713643jabber_
jabbers183610583jabbers
jibber174111243jibber_
jibbers18449703jibbers
jobbed184212133jobbe_d
joinery17366593joinery
libber104414013libber_
libbers113812833libbers
lobbed113114613lobbe_d
lobby125113923lobb__y
lobbyer1433913lobbyer_
lobbyers1533193lobbyers
lottery10389833lottery
lowery124112713lo_wery
lubber104214623lubber_
lubberly1543663lubberly
lubbers113913723lubbers
mobbed137112243mobbe_d
mockery18376913mockery
monkery16317453monkery
mopery135210973mo_pery
mothery153710513mothery
nabber104913543nabber_
nabbers113710463nabbers
nabobery1542433nabobery
nobbier11309163nobbier_
nobbily1436693nobbily
nobbler113211183nobbler_
nobblers12318563nobblers
nobby125513463nobb__y
nobler83713453nobler_
obey96521303_o_be_y
obvert11412993_obvert
ochery14319443_ochery
omber95316443_omber_
ombers104214403_ombers
onery8414123_o_nery
ornery938463_ornery
orrery936783_orrery
popery134511703po_pery
pottery123011073pottery
powdery16396123powdery
ribber103515493ribber_
ribbers113913183ribbers
robbed113415193robbe_d
robotry1244163robotry
rockery16439253rockery
roguery1134893roguery
rookery14398313rookery
ropery114313873ro_pery
rosery93813283ro_sery
rubber104715793rubber_
rubbers113913183rubbers
slabbery15375773slabbery
slobber11388903slobber_
slobbers12398523slobbers
sobbed113516263sobbe_d
sober74822403so_ber_
soberly1236943so_berly
sobers85218853so_bers
somber103713993somber_
somberly1544053somberly
sorcery1237023sorcery
swobber14336543swobber_
swobbers15355593swobbers
timbery14256893timbery
toggery12505923toggery
tottery10388483tottery
towery124012093to_wery
tubber104313203tubber_
tubbers113411243tubbers
volery1237873vo_lery
wobbler14329823wobbler_
wobblers15327883wobblers
wobbly16347093wobb_ly
yabber136111833yabber_
yabbers14389353yabbers

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272628.15616432.9
3Display Results2622620.2031290.6
 (SQL Overall)1786912628.51520985.4
 
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.