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

227 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
lobbyer143391(None) 
lobber104016601lobb_er
lobbyers1533191lobbyers
bobber95016742bobb_er
clobber13378162clobb_er
cobber124116842cobb_er
cobbier133410162cobbier
cobbler133311822cobbler
dobber114015422dobb_er
globbier1334242globbier
gobbler123310022gobbler
hobber134114632hobb_er
hobbler143710402hobbler
jobber173813352jobb_er
libber104414012libb_er
lobbed113114612lobb_ed
lobbers113713942lobb_ers
lobbied12337172lobbied
lobbies113612462lobbies
lobby125113922lobby__
lobster9288852lobster
lubber104214622lubb_er
mobber123613462mobb_er
nobbier11309162nobbier
nobbler113211182nobbler
obeyer1135892_obeyer
robber103916532robb_er
slobber11388902slobb_er
slobbier1254632slobbier
sobber104016592sobb_er
wobbler14329822wobbler
babbler104012823babbler
bibber94613573bibb_er
blabber10418923blabb_er
blobbed11366563blobb_ed
blubber10399293blubb_er
bobbed104315833bobb_ed
bobbers103614283bobb_ers
bobbery13438353bobb_ery
bobbies103714563bobbies
bobble94115143bobble_
bobbled113811833bobbled
bobbles104514913bobbles
bobby114814663bobby__
bomber125014653bomb_er
boneyer1237403boneyer
bowyer14368923bo_wyer
bubbler103611783bubbler
buyer105013093__buyer
clabber134210113clabb_er
clobbers14397513clobb_ers
clubber13319593clubb_er
clubbier1434833clubbier
cobbers134114753cobb_ers
cobble123615263cobble_
cobbled143411633cobbled
cobblers14359593cobblers
cobbles133814823cobbles
cobby145516413cobby__
comber125118503comb_er
coyer105222843co__yer
dabber114816963dabb_er
dabbler124012153dabbler
dibber114614713dibb_er
dibbler124510283dibbler
dobbers123513253dobb_ers
dobbies124113063dobbies
dobby136013633dobby__
doubler103110083doubler
doubter10298353doubter
dubber113814553dubb_er
fabber134814113fabb_er
fibber134811933fibb_er
flabbier1534093flabbier
flubber14287713flubb_er
fobbed144112613fobb_ed
forayer13368953forayer
forbye14427883forbye_
foyer116416553fo__yer
gabber114916603gabb_er
gabbier12379633gabbier
gabbler124013303gabbler
gibber114112863gibb_er
glibber1235163glibb_er
globby1434683globby__
gobbed124613883gobb_ed
gobbet114214443gobb_et
gobble113512983gobble_
gobbled134010253gobbled
gobblers13308343gobblers
gobbles123512583gobbles
goober93911743goob_er
hobbed144114303hobb_ed
hobbers143512343hobb_ers
hobbies143813343hobbies
hobble133913433hobble_
hobbled153310783hobbled
hobblers15308513hobblers
hobbles143313783hobbles
hobby155913733hobby__
jabber173713643jabb_er
jibber174111243jibb_er
jobbed184212133jobb_ed
jobbers182911133jobb_ers
jobbery21366013jobb_ery
knobbier1652703knobbier
labeler92310183labeler
laborer9249513laborer
lamber104418493lamb_er
lambier113611643lambier
lawyer12386973l_awyer
layer84626473l__ayer
libbers113812833libb_ers
libeler9219003libeler
liber74723623l_ib_er
limber104316793limb_er
limbier11349113limbier
livyer12426293l_ivyer
loader74316313lo_ader
loafer93610943lo_afer
loamier9349163loamier
loaner64416503lo_aner
loather103711003loather
lobar7313013lo_b_ar
lobate82915243lobate_
lobated102610943lobated
lobbing123110913lobbing
lobbygow195883lobbygow
lobbying1633603lobbying
lobbyism1742813lobbyism
lobbyist1543533lobbyist
lobe65535363lo_b_e_
lobed86022133lo_b_ed
lobes75331003lo_b_es
lobsters10268743lobsters
lobular936663lobular
lobule82910063lobule_
lobules92510813lobules
locater93113603locater
locker124019423lo_cker
lodger86517693lo_dger
lofter94614723lo_fter
loftier1037763loftier
logger86420003lo_gger
loggier93811143loggier
logier75015733lo_gier
loiter64619173lo_iter
loller63315283lo_ller
loner55431043lo__ner
longer75823203lo_nger
loobies93814103loobies
looby108115623looby__
looker104816953lo_oker
loonier73312683loonier
looper83817113lo_oper
loopier93711193loopier
looser65219943lo_oser
looter64222323lo_oter
loper75129233lo__per
lopper103717203lo_pper
loppier11369723loppier
lorimer937753lorimer
loriner7511893loriner
loser54728673lo__ser
lotter64025603lo_tter
louder74414603lo_uder
lounger84610213lounger
lousier72411623lousier
louver94110393lo_uver
lover85526453lo__ver
lowbred13225363lowbred
lower85830413lo__wer
lowlier10338903lowlier
loyaler1035083loyaler
lubbers113913723lubb_ers
lumber103817773lumb_er
mobbed137112243mobb_ed
mobbers133610923mobb_ers
mobster11299213mobster
moneyer1237903moneyer
nabber104913543nabb_er
nibbler11379273nibbler
nobble103814313nobble_
nobbled123511283nobbled
nobblers12318563nobblers
nobbles114014523nobbles
nobby125513463nobby__
nobler83713453no_bler
nubbier11308133nubbier
obeyed1235823_obeyed
obeyers1234813_obeyers
omber95316443_omb_er
orbier839993_orbier
oyer75927653_o__yer
rabbler113514093rabbler
ribber103515493ribb_er
ribbier1137593ribbier
robbed113415193robb_ed
robbers112814163robb_ers
robbery14348283robb_ery
rubber104715793rubb_er
slabber113311393slabb_er
slobberer13153443slobberer
slobbers12398523slobb_ers
slobbery15375663slobb_ery
slobby1334803slobby__
slubber113010763slubb_er
snobbier1234633snobbier
sobbed113516263sobb_ed
sobbers114114263sobb_ers
sober74822413so_b_er
soberer93110353soberer
somber103714003somb_er
swobber14336543swobb_er
toyer84521553to__yer
tubber104313203tubb_er
tubbier11237743tubbier
wabbler143511923wabbler
webbier1445423webbier
wobble133212313wobble_
wobbled15349593wobbled
wobblers15327883wobblers
wobbles143412433wobbles
wobblier15325203wobblier
wombier1436543wombier
yabber136111833yabb_er
yobboes1445583yobboes

Search took 8 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.420425454.8
2DLD Change Limit1340272277.34318252.3
3Display Results2272270.0962364.6
 (SQL Overall)1786912277.85922737.1
 
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.