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

193 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
jobbery2136601(None) 
bobbery13438351bobbery
jobber173813351jobber_
jobbers182911131jobbers
robbery14348281robbery
bibbery13426542bibbery
bobber95016742bobber_
bobbers103614282bobbers
cobber124116842cobber_
cobbers134114752cobbers
dobber114015422dobber_
dobbers123513252dobbers
hobber134114632hobber_
hobbers143512342hobbers
jabber173713642jabber_
jabbers183610582jabbers
jibber174111242jibber_
jibbers18449702jibbers
jobbed184212132jobbe_d
joinery17366592joinery
lobber104016602lobber_
lobbers113713942lobbers
mobber123613462mobber_
mobbers133610922mobbers
robber103916532robber_
robbers112814162robbers
rubbery14337592rubbery
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
clobber13378163clobber_
clobbers14397513clobbers
cobbier133410163cobbier_
cobbler133311823cobbler_
cobblers14359593cobblers
cobby145516413cobb__y
comber125118503comber_
combers134516623combers
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
jabbed184213483jabbe_d
jabbered2034433jabbered
jabberer1944023jabberer
jaggery19336903jaggery
japery18439143j_apery
jaspery19405253jaspery
jibbed184810563jibbe_d
jiber145115703j_iber_
jibers155912883j_ibers
jittery17346443jittery
jobberies20115423jobberies
jobbing19279013jobbing
jobless16237563jobless
jockey22408033jocke_y
joey145719333jo__e_y
jogger154713163jogger_
joggers164110693joggers
joiner134114133joiner_
joiners144211573joiners
joker165715893jo_ker_
jokers175511193jo_kers
jokey195014693jo_ke_y
jokier17618753jokier_
jolter133513093jolter_
jolters143711993jolters
josher164312963josher_
joshers174111593joshers
jotter134315633jotter_
jotters143413803jotters
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
robotry1244173robotry
rockery16439253rockery
roguery1134893roguery
rookery14398313rookery
ropery114313873ro_pery
rosery93813283ro_sery
rubber104715793rubber_
rubbers113913193rubbers
slabbery15375773slabbery
slobber11388903slobber_
slobbers12398523slobbers
sobbed113516263sobbe_d
sober74822413so_ber_
soberly1236943so_berly
sobers85218863so_bers
somber103714003somber_
somberly1544053somberly
sorcery1237033sorcery
swobber14336543swobber_
swobbers15355593swobbers
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.403443402.0
2DLD Change Limit1340271936.20321606.8
3Display Results1931930.0633063.5
 (SQL Overall)1786911936.66926794.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.