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

224 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
benthos123837(None) 
benthon1237691benthon
benthons1337971benthons
bentos86218301bent_os
bathos116215632b_athos
benches143918602benches
benthal1247952benthal
benthic1437472benthic
benthoses1446692benthoses
bento75922952bent_o_
bents76033692bent__s
berthas12398762berthas
berths114712422berth_s
beths105519222be_th_s
centos85920462cent_os
ethos85514192_e_thos
gentoos838632gentoos
lentos65317402lent_os
menthol1236722menthol
menthols1347032menthols
obentos936702obent_os
tenths94412662tenth_s
anchos114214893_anchos
anethol1045383anethol
anethols1145843anethols
bancos104713893ban_cos
banjos15378893ban_jos
bantams1149063bantams
banters94623113banters
banties94324763banties
bathes116524833b_athes
baths105922923b_ath_s
beaches144120653beaches
beanos85516513be_anos
beaters94925043beaters
beats76042243beat__s
beeches143413883beeches
beetles9312083beetles
beets76131443beet__s
belches143514343belches
bellhop1445053bellhop
bellhops1544873bellhops
belters93819413belters
belts75931163belt__s
benames112814603benames
bench125619503bench__
benched154713943benched
bencher144113483bencher
benchers153611013benchers
benchtop1742173benchtop
bendays13327513bendays
bendees103913863bendees
benders104021063benders
bends85628973ben__ds
bendys12518383ben_dys
benes75536233ben__es
benison937123benison
benisons1037043benisons
bennes86019013ben_nes
bennets94712163bennets
bennies93917313bennies
bennis84314803ben_nis
bens65945703ben___s
bent67759913bent___
benthonic1644593benthonic
bentwood1444453bentwood
bentwoods1543993bentwoods
benumbs1333543benumbs
benzins1838693benzins
benzol1756993ben_zol
benzols1836673benzols
benzyls2133673benzyls
berth104917883berth__
bertha11429173berth_a
berthed13259123berthed
bestirs9311133bestirs
bestow1149463best_ow
bestows1248863bestows
bestrow1237243bestrow
bestrows1337043bestrows
bests75932613best__s
bestuds10326753bestuds
betas75528763be_t_as
betels84515063be_tels
beth96629233be_th__
bethel1169643be_thel
bethels1238533be_thels
bethorn1238643be_thorn
bethorns1337323be_thorns
beton76022063be_t_on
betons84919553be_tons
betook12439603be_took
bets67051443be_t__s
bettas84913923be_ttas
betters94422093betters
bettor83612223be_ttor
bettors93312473bettors
bingos95514793bin_gos
bints76130183bint__s
births115713603birth_s
bistros92810983bistros
blenches153310763blenches
bohos105618253b__ohos
bongos95316653bon_gos
bonitos939733bonitos
bonobos1136393bonobos
booths115313793booth_s
breathes134212903breathes
breaths124411183breath_s
brents84717273brent__s
briths115113863brith_s
bronchos15206173bronchos
broths115013923broth_s
bunches144116033bunches
buncos104011593bun_cos
bunkos124210323bun_kos
bunters94717123bunters
bunts75729803bunt__s
buteos84913413b_uteos
canthus1248713canthus
cantos84826973cant_os
centals94317053centals
centas85020703cent_as
centavos1344783centavos
centers94420603centers
centimos12507323centimos
cento76625173cent_o_
centres93817123centres
cents74730333cent__s
centums11398783centums
cestos84718093cest_os
conchos144313963conchos
contos84923233cont_os
deaths105914443death_s
dentals83915393dentals
dentils84115583dentils
dentins83419223dentins
dents65031803dent__s
depths12428573depth_s
echos105216463_e_chos
enters64425643_enters
enthuse1046963_enthuse
ethnos947053_e_thnos
eths76619523_e_th_s
fenthion1444613fenthion
fenthions1544233fenthions
genros74211333gen_ros
gentes75324163gent_es
gentles83714343gentles
gentoo7311313gent_oo
gents65729613gent__s
heaths126316383heath_s
hents87330743hent__s
heths116317783he_th_s
honchos15369573honchos
intros64215773_intros
juntos134110843junt_os
kenches163912273kenches
kendos114510663ken_dos
kenos95220623ken__os
kentes105118653kent_es
lekythos1851663lekythos
lengths1144083length_s
lenos56024863len__os
lentils73912973lentils
lento57223393lent_o_
lethes94818083le_thes
lithos94212553_lithos
menshes12310443menshes
mentees93214503mentees
mention9314373mention
mentions10312893mentions
mentor8414363ment_or
mentors9314993mentors
menudos1034643menudos
method1239023me_thod
methods1338883me_thods
meths105320233me_th_s
metros84217803me_tros
months113812933month_s
mythos14398463_mythos
ninths936933ninth_s
obento837893obent_o_
pantos85222743pant_os
pathos115516693_pathos
pengos94612413pen_gos
pentads1039523pentads
penthouse1446263penthouse
pentose9311593pent_ose
pentyls1236523pentyls
pestos84719083pest_os
pintos86021293pint_os
ponchos143410703ponchos
pothos114214693_pothos
puntos85915793punt_os
ranchos123911393ranchos
rectos85718783rect_os
rentals74017473rentals
renters74224813renters
rentes65431193rent_es
rents55935183rent__s
retros63820193re_tros
santos64421833sant_os
seethes103613743seethes
senhor93010813sen_hor
senhors103512133sen_hors
sentimos10407423sentimos
sextos134012163sext_os
synths12377883synth_s
teethes103611653teethes
tenches123515523tenches
tenters73921103tenters
tenth85421833tenth__
tenthly1335743tenthly
tents56434213tent__s
tenutos736623tenutos
teths85418513te_th_s
venters103717733venters
vents86125933vent__s
wenches152914133wenches
xanthous1846643xanthous
yentas94614213yent_as
yentes95517603yent_es
zeniths1935153zenith_s

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.466383457.1
2DLD Change Limit1340272247.14318763.4
3Display Results2242240.0762947.4
 (SQL Overall)1786912247.68523251.9
 
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.