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

197 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
lowboy143590(None) 
cowboy1637061cowboy
lowboys1534211lowboys
plowboy1743181plowboy
blowby16467512blowb_y
cowboys1735252cowboys
lobby125113922lo_bby
lobo67229862lo_bo_
lobos75921842lo_bos
looby108115622loob_y
lowborn1245142lowborn
lowbrow1543272lowbrow
lowery124112712lowery
lowly114113332low_ly
plowboys1842362plowboys
poboy121612222po_boy
potboy1397812potboy
tomboy1358212tomboy
batboy1387533batboy
blowbys17353813blowbys
blowfly1843243blowfly
blowjob2141753blowjob
blowsy14579453blow_sy
blowy134315323blow__y
blowzy23516673blow_zy
bobby114814663bo_bby
bonbon10310073bonbon
booboo1039463booboo
booby125319513boob_y
boubou1038433boubou
bowery146012113bowery
bowpot13410073bowpot
bowwow1334463bowwow
boy87753563___boy
busboy13307443busboy
carboy134914183carboy
cobby145516413co_bby
colby124415063colb_y
combo114519433combo_
combos125316613combos
convoy14348543convoy
copyboy1963513copyboy
corby125018533corb_y
cowboyed1943373cowboyed
cowpox2035003cowpox
cowry135512483cow_ry
cowy126427363cow__y
dobby136013633do_bby
doby106022163do_b_y
doubly12328963doubly
dowdy136112543dow_dy
dowery134311663dowery
downbow1653393downbow
downy125714553dow_ny
dowry126312483dow_ry
flowery16327783flowery
flyboy17113913flyboy
fogbow1544783fogbow
footboy1544913footboy
forby135317673forb_y
globby1434683glo_bby
glowfly1742673glowfly
gobo76126903go_bo_
gobony1236913go_bony
gobos86219383go_bos
goby106021083go_b_y
gombo105814043gombo_
gombos114311093gombos
gowany13457493gowany
hobby155913733ho_bby
hobo97026083ho_bo_
hobos106321353ho_bos
homeboy1746153homeboy
hotbox1835703hotbox
howdy155711413how_dy
jowly186410903jow_ly
kobo107422103ko_bo_
kobos115616893ko_bos
kowtow1643463kowtow
labor75117313l_abor
lamby125114843lamb_y
lawbook1644033lawbook
lawny115912013law_ny
lesbo739253lesbo_
lesbos837403lesbos
lewdly1334403lewdly
limbo95614813limbo_
limbos104712143limbos
limby125714073limb_y
linkboy1643173linkboy
loamy105913343lo_amy
lob57154463lo_b__
lobar7313013lo_bar
lobbed113114613lobbed
lobber104016603lobber
lobe65535363lo_b_e
lobed86022133lo_bed
lobes75331003lo_bes
lobs66441083lo_b_s
lobworm1445253lobworm
lockbox2243383lockbox
loco67030743lo_co_
locos75822603lo_cos
lofty115813303lo_fty
logbook1454513logbook
loggy105714193lo_ggy
logily1039833logily
logion76013723logion
logo57931763lo_go_
logoi69715943lo_goi
logon615922313lo_gon
logos67225333lo_gos
logway1335913logway
logwood1255573logwood
logy87025783lo__gy
lollop8238783lollop
lollopy12234773lollopy
lolly85120663lo_lly
lonely92912473lonely
longbow1343863longbow
longly10279603longly
loo38359823lo__o_
looey84822913lo_oey
loof78141053lo__of
look87333473lo__ok
loom67035053lo__om
loon47344793lo__on
looney94712413looney
loony86918963lo_ony
loop67835013lo__op
loopy105316643lo_opy
loos49051123lo__os
loot46955823lo__ot
loppy125911663lo_ppy
lordly1038753lordly
lorry86315673lo_rry
lory75931713lo__ry
lossy85214643lo_ssy
lotion65716523lotion
lotos54724633lo_tos
lotto55217573lotto_
lottos64613103lottos
loudly1037783loudly
loungy10476833loungy
loury85716753lo_ury
lousy84617083lo_usy
lovably15187063lovably
lovely12339713lovely
low66051873low___
lowball1275503lowball
lowbred13225363lowbred
lowbrows1643483lowbrows
lowdown1454483lowdown
lowe75435313low__e
lowed95233903low_ed
lower85830413low_er
lowers94624923lowers
lowes85732463low_es
lowest93915593lowest
lowing104623273lowing
lowish12310533lowish
lowlily1335353lowlily
lown76929293low__n
lows75843013low__s
lowse87219903low_se
newsboy1542493newsboy
nobby125513463no_bby
nobly105314403no_bly
nobody1235743no_body
nonbody1344823nonbody
noway111112843now_ay
obey96521303_o_bey
oboe66822943_o_boe
obol65220613_o_bol
orby97519603_orb_y
oxbow1734443_oxbow
playboy1743813playboy
poboys1397313po_boys
postboy1476673postboy
potboys1475273potboys
powwow1342833powwow
robot7325973ro_bot
rowboat1267983rowboat
rowdy125711533row_dy
shopboy1743803shopboy
slobby1334803slo_bby
slowly1237153slow_ly
toby96322293to_b_y
tomboys1435713tomboys
towboat1258303towboat
towery124012093towery
towny116114493tow_ny
towy105325473tow__y
wobbly16347093wobbly
womby155910093womb_y
yobbo1237873yobbo_
yobbos1335963yobbos

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 Filter1786911127160.373479064.3
2DLD Change Limit1127161975.64319974.5
3Display Results1971970.0633127.0
 (SQL Overall)1786911976.07929394.8
 
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.