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

280 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
tomboy135821(None) 
tomboys1435711tomboys
combo114519432combo_
combos125316612combos
cowboy1637062cowboy
gombo105814042gombo_
gombos114311092gombos
homeboy1746152homeboy
lowboy1435902lowboy
poboy121612222po_boy
potboy1397812potboy
toby96322292to_b_y
tomb89029652tomb__
tombac12258882tombac
tombak14237752tombak
tombal102311022tombal
tombed113812132tombed
tombola1146092tombola
tombolo1146102tombolo
tombs97818732tomb_s
tomcod1135782tomcod
tommy124712232tom_my
womby155910092womb_y
ambo88225143_ambo_
ambos95321253_ambos
ambry123512103_ambry
atomy107415193atom__y
attaboy1264303attaboy
bamboo12310013bamboo
batboy1387533batboy
bimbo114811873bimbo_
bimbos124610523bimbos
bobby114814663bo_bby
bomb106927423bomb__
bombax1935753bombax
bombe115519313bomb_e
bombed134113873bombed
bomber125014653bomber
bombes124916823bombes
bombs115818823bomb_s
bombyx2232693bombyx
bonbon10310073bonbon
booboo1039463booboo
booby125319513boob_y
boombox2073613boombox
boubou1038433boubou
boy87753563___boy
busboy13307443busboy
carboy134914183carboy
cobby145516413co_bby
coembody1842493coembody
colby124415063colb_y
comb106632113comb__
combat12316753combat
combe116223543comb_e
combed135516543combed
comber125118503comber
combes125321733combes
combs116122963comb_s
comedy14378233comedy
comely134213733comely
comfy153710213com_fy
comity13312713comity
common12310803common
commy144712643com_my
comply152810383comply
compo115318573compo_
compony1613011913compony
compos124818803compos
convoy14348543convoy
copyboy1963513copyboy
corby125018533corb_y
cowboys1735253cowboys
dobby136013633do_bby
doby106022163do_b_y
doubly12328963doubly
dumbly14399603dumbly
dumbo105614063dumbo_
dumbos114111083dumbos
embay123410603_embay
embody1435033_embody
emboly1336723_emboly
embow1297563_embow
flyboy17113913flyboy
fogbow1544783fogbow
footboy1544913footboy
forby135317673forb_y
gambol1138223gambol
gobo76126903go_bo_
gobony1236913go_bony
gobos86219383go_bos
goby106021083go_b_y
goombay1543553goombay
gumbo104413583gumbo_
gumbos114610873gumbos
hobby155913733ho_bby
hobo97026083ho_bo_
hobos106321353ho_bos
hombre13309303hombre
homebody1954053homebody
homeboys1845513homeboys
homely145313173homely
homey135924843hom_ey
homily144712333homily
hominy144511483hominy
hommos13128503hommos
homo96126473hom_o_
homos105921783hom_os
homy126623223hom__y
hotbox1835703hotbox
humbly164010523humbly
imbody1434113_imbody
jomon14610083jom_on
jumbo164311073jumbo_
jumbos17379123jumbos
kobo107422103ko_bo_
kobos115616893ko_bos
kombu1347243komb_u
kombus1435523kombus
lamby125114843lamb_y
limbo95614813limbo_
limbos104712143limbos
limby125714073limb_y
lobby125113923lo_bby
lobo67229863lo_bo_
lobos75921843lo_bos
looby108115623loob_y
lowboys1534213lowboys
mambo115215743mambo_
mambos125414493mambos
mommy114010753mom_my
mumbly15319463mumbly
nimbly13388773nimbly
nobby125513463no_bby
nobly105314403no_bly
nobody1235743no_body
nomoi76012533nom_oi
nomos75919743nom_os
nonbody1344823nonbody
numbly134410663numbly
obey96521303_o_bey
oboe66822943_o_boe
obol65220613_o_bol
omber95316443_omber
ombre94111803_ombre
orby97519603_orb_y
oxbow1734443_oxbow
plowboy1743183plowboy
poboys1397313po_boys
pommy14449863pom_my
pomo85828453pom_o_
pomos95321583pom_os
pompom1436493pompom
pompon1238943pompon
postboy1476673postboy
potboys1475273potboys
robot7325973ro_bot
romeo73719703romeo_
romeos84013173romeos
rumbly134412163rumbly
sambo95118013sambo_
sambos104315193sambos
shopboy1743803shopboy
somber103714003somber
sombre10729473sombre
somebody1642923somebody
symbol1336083symbol
tabby125213893t_abby
taboo73418093t_aboo
tabor75518393t_abor
tallboy1265143tallboy
tambac122210243tambac
tambak14249263tambak
tambour1136353tambour
tambur10358713tambur
tamely113711953tamely
tammy124013223tam_my
tampon102911233tampon
tannoy958353tannoy
teabox1536013teabox
teapoy1138113teapoy
temblor1144093temblor
tempo95214973tempo_
tempos103812293tempos
tepoy10312163t_epoy
timbal102510753timbal
timber104012683timber
timbery14256893timbery
timbre10328633timbre
timely113410113timely
toady96814343to_ady
toasty9509563toasty
today96416953to_day
toddy106812423to_ddy
tody86327213to__dy
toffy145310283to_ffy
tokay125513053to_kay
toluol636903toluol
tom514358053tom___
toman75724053tom_an
tomans85419133tomans
tomato8313453tomato
tomatoey1344103tomatoey
tomback17227743tomback
tombacs13248443tombacs
tombaks15246863tombaks
tombing123310533tombing
tombolas1246013tombolas
tombolos1245103tombolos
tomboyish1952423tomboyish
tomcat101013453tomcat
tomcods1234873tomcods
tome67543193tom__e
tomes76037383tom_es
tomfool1254243tomfool
tommed113310143tommed
tompion11247103tompion
toms68343493tom__s
tomtit8413853tomtit
tondo69718683tondo_
tondos75115923tondos
toney86027413to_ney
tony75635153to__ny
too38965423to__o_
took86531073to__ok
tool46735683to__ol
toolbox1653633toolbox
toom66532933to__om
toon47740633to__on
toot45958883to__ot
toothy12529693toothy
tootsy9437983tootsy
topo66932403to_po_
topoi76018353to_poi
topos75726393to_pos
torchy14549533torchy
toro48045683to_ro_
toros54336193to_ros
torot56139943to_rot
torpor839193torpor
torso56922143torso_
torsos64815733torsos
tory75840543to__ry
touchy145010503touchy
toughy135911073toughy
towboat1258303towboat
towery124012093towery
towny116114493to_wny
towy105325473to__wy
toy69655193t___oy
toyo76925453to_yo_
toyon86715673to_yon
toyos87519143to_yos
trebly1138973trebly
trembly1435523trembly
trombone1245363trombone
troy77429683t__roy
tubby124511403t_ubby
tumble103215643tumble
tumefy1434223tumefy
tummy124711993tum_my
tumor71110693tum_or
turbo71015043turbo_
turbos8910783turbos
turbot8914263turbot
tymbal13236823tymbal
umbo85516663_umbo_
umbos94613073_umbos
wambly16388663wambly
wobbly16347093wobbly
womb117022233womb__
wombat1339863wombat
wombed14419233wombed
wombs125813343womb_s
yobbo1237873yobbo_
yobbos1335963yobbos
zombi1838993zomb_i
zombie1937323zombie
zombify2642253zombify
zombis1936283zombis

Search took 6 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.1401276364.3
2DLD Change Limit1127162805.36021029.1
3Display Results2802800.0933010.8
 (SQL Overall)1786912805.59331949.0
 
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.