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

266 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
robbery1434828(None) 
bobbery13438351bobbery
jobbery21366011jobbery
robber103916531robber_
robbers112814161robbers
rubbery14337591rubbery
bibbery13426542bibbery
bobber95016742bobber_
bobbers103614282bobbers
cobber124116842cobber_
cobbers134114752cobbers
dobber114015422dobber_
dobbers123513252dobbers
hobber134114632hobber_
hobbers143512342hobbers
jobber173813352jobber_
jobbers182911132jobbers
lobber104016602lobber_
lobbers113713942lobbers
mobber123613462mobber_
mobbers133610922mobbers
ribber103515492ribber_
ribbers113913182ribbers
robbed113415192robbe_d
robotry1244172robotry
rockery16439252rockery
roguery1134892roguery
rookery14398312rookery
ropery114313872ro_pery
rosery93813282ro_sery
rubber104715792rubber_
rubbers113913192rubbers
slobbery15375662slobbery
snobbery15514292snobbery
sobber104016592sobber_
sobbers114114262sobbers
abbey125714933_abbe_y
ambery133811133_ambery
beery105220123__beery
bibber94613573bibber_
bibbers103911353bibbers
blubbery14294783blubbery
bobbed104315833bobbe_d
bobby114814663bobb__y
bomber125014653bomber_
bombers134512593bombers
bootery1238983bootery
bowery146012113bo_wery
boxberry2242653boxberry
bribery14426493bribery
broguery1443313broguery
broidery14356083broidery
clobber13378163clobber_
clobbers14397513clobbers
cobbier133410163cobbier_
cobbler133311823cobbler_
cobblers14359593cobblers
cobby145516413cobb__y
comber125118503comber_
combers134516623combers
cookery164210393cookery
coopery143910273coopery
coppery16409393coppery
cowberry1843343cowberry
crabber133810733crabber_
crabbers14358753crabbers
cribber13367663cribber_
cribbers14306443cribbers
crockery19356603crockery
crookery17415993crookery
crowberry1942373crowberry
dabber114816963dabber_
dabbers123813213dabbers
daubery13396213daubery
dibber114614713dibber_
dibbers124013173dibbers
dobby136013633dobb__y
doddery13516853doddery
dodgery13627783dodgery
dogberry1542863dogberry
doggery13448263doggery
dowery134311663do_wery
drabber12438593drabber_
drollery12314793drollery
drubber12357863drubber_
drubbers13386033drubbers
dubber113814553dubber_
dubbers124011823dubbers
fabber134814113fabber_
fibber134811933fibber_
fibbers144510603fibbers
fobbed144112613fobbe_d
foolery1336693foolery
foppery17385623foppery
forgery14419303forgery
gabber114916603gabber_
gabbers124612833gabbers
gibber114112863gibber_
gibbers124710983gibbers
gobbed124613883gobbe_d
gobbet114214443gobbe_t
gobbets12327643gobbets
gobbler123310023gobbler_
gobblers13308343gobblers
goober93911743goober_
goobers10219623goobers
grabber12389763grabber_
grabbers13337883grabbers
grocery13336763gro_cery
groggery1433513groggery
grubber12417913grubber_
grubbers13316203grubbers
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
orbier839993orbier_
ornery938463_ornery
orrery936783_orrery
popery134511703po_pery
pottery123011073pottery
powdery16396123powdery
prober104516073pro_ber_
probers113514583pro_bers
rabbet103818653rabbe_t
rabbets11279423rabbets
rabbitry15243383rabbitry
rabbity14266303rabbity
rabbler113514093rabbler_
rabblers123810853rabblers
rebbe9313163rebbe__
rebbes10313533rebbe_s
rebury11349213r_ebury
revery124014213r_every
ribbed114014373ribbe_d
ribbier1137593ribbier_
ribbony1443543ribbony
ribby12419683ribb__y
ribier84414233ribier_
ribiers9319753ribiers
riflery13345803riflery
roamer84715163roamer_
roamers93713463roamers
roarer63914333roarer_
roarers73812743roarers
robberies13107393robberies
robbin103611183robb_in
robbing123313213robbing
robbins112811063robbins
robe65335643ro_be__
robed85323733ro_be_d
robes75133303ro_be_s
roble75223023roble__
robles85321693roble_s
rocker124319573rocker_
rockers133916553rockers
rocketry1744503rocketry
roger64521413ro_ger_
rogers74517913ro_gers
rolfer94412273rolfer_
rolfers104011813rolfers
roller63919793roller_
rollers73117473rollers
romper104213683romper_
rompers113412243rompers
roofer94415283roofer_
roofers105013903roofers
roomer84718633roomer_
roomers95416413roomers
rooser63921883rooser_
roosers74217883roosers
rooter64926033rooter_
rooters74522933rooters
roper75431913ro_per_
ropers84325903ro_pers
ropey106021873ro_pe_y
ropier84118813ropier_
rosary92810353ro_sary
rosebay12135773rosebay
rosier64221273rosier_
roster64329083roster_
rosters73727553rosters
rotary92411303ro_tary
rotter64325463rotter_
rotters74421393rotters
rouser65224083rouser_
rousers75220143rousers
router65025843router_
routers74822873routers
rover85527373ro_ver_
rovers95423523ro_vers
rower85430493ro_wer_
rowers94924573ro_wers
rozzer1437353rozzer_
rozzers1535633rozzers
rubbed114515083rubbe_d
rubbered1335383rubbered
rubbly133710613rubb_ly
rubby124413863rubb__y
rubier84814743rubier_
rudery10419033r_udery
shrubbery1941703shrubbery
slabbery15375773slabbery
slobber11388903slobber_
slobbers12398523slobbers
sobbed113516263sobbe_d
sober74822413so_ber_
soberly1236943so_berly
sobers85218863so_bers
somber103714003somber_
somberly1544053somberly
sorcery1237033sorcery
swobber14336543swobber_
swobbers15355593swobbers
throbber1543203throbber_
throbbers1643173throbbers
timbery14256893timbery
toggery12505923toggery
tottery10388483tottery
towery124012093to_wery
tubber104313203tubber_
tubbers113411253tubbers
volery1237873vo_lery
wobbler14329823wobbler_
wobblers15327883wobblers
wobbly16347093wobb_ly
yabber136111833yabber_
yabbers14389353yabbers

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272666.40620922.1
3Display Results2662660.0932860.2
 (SQL Overall)1786912666.88925938.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.