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

384 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
tophus11521036(None) 
tophes115218421tophes
tophs105220051toph_s
typhus14395711typhus
kophs145010932koph_s
opus66420592_op_us
qophs19507812qoph_s
sophs104916022soph_s
thus76721472t__hus
tofus86415422to_fus
tolus55024482to_lus
tonus56324302to_nus
topees85519702topees
topers85025322topers
topes76941762top_es
topful1136542topful
toph96326872toph__
tophe106718972toph_e
tophi105215302toph_i
topics104714582topics
topis76025832top_is
topos75726392top_os
tops66248122top__s
torous64319022torous
torus54329762to_rus
toshes94520102toshes
typhous1566322typhous
alphas1139513alphas
aphis105917133_aphis
atopies92816433atopies
boches134618523boches
bogus85616473bo_gus
bohos105618253bo_hos
bolus79125543bo_lus
bonus75324323bo_nus
bops86037983bop__s
boshes114721883boshes
bupkus14385683bupkus
caphs124515373caph_s
coccus979283coccus
cohos105921853co_hos
coitus8511893coitus
coleus86818273coleus
comous10816493comous
conus76726533co_nus
copals105018943copals
copays134911273copays
copens106119963copens
copers104629843copers
copes97747103cop_es
copies104130303copies
copihue1444143copihue
copihues1543993copihues
copious11311963copious
copout10418773copout
copouts11311073copouts
copras103517153copras
cops86751373cop__s
copses104922473copses
cornus84816563cornus
corpus106015293corpus
coshes115022783coshes
coypous14248803coypous
coypus13389303coypus
cyprus1335363cyprus
doofus1036163doofus
dopas85019063dop_as
dopers95522483dopers
dopes84935043dop_es
ephas10311543_ephas
fichus14388103fichus
focus105815883fo_cus
foehns12204973foehns
foetus958523foetus
fohns117310783fo_hns
fondus105210943fondus
fops96532683fop__s
gopher1239183gopher
gophers1338983gophers
goths96513003goth_s
hocus104715203ho_cus
hopers114222973hopers
hopes105835643hop_es
hops97942633hop__s
iodous7311493iodous
jehus15488573_jehus
johns15398713jo_hns
joshes165114853joshes
joyous16276753joyous
kaphs144911503kaph_s
kohls12437803ko_hls
kombus1435523kombus
kopeks1134603kopeks
koph135816543koph__
kopjes1935363kopjes
koppas14407603koppas
kops107031293kop__s
lapsus8437273lapsus
lochs106715513loch_s
locus74819993lo_cus
lopers84424143lopers
lopes76437343lop_es
lops66043353lop__s
lotus55718063lo_tus
lupous849433lupous
lupus74512523lup_us
mochas13310653mochas
modus85417203mo_dus
moghul1244473moghul
moghuls1343613moghuls
mohur1036513mo_hur
mohurs1135933mo_hurs
momus96116113mo_mus
mopeds11499663mopeds
mopers104220373mopers
mopes95134983mop_es
mops85940133mop__s
morphos14159083morphos
morphs13149433morph_s
moshes115222873moshes
moths106021553moth_s
nodous7711323nodous
nodus66315993no_dus
nonplus936183nonplus
nopals84914023nopals
noshes96618233noshes
nous46136983no__us
octopus1144803octop_us
ohms95514033_o_hms
ohs66232313_o_h_s
onus45826813_o_nus
oohs75220693_ooh_s
oomphs1344723oomph_s
oops65232673oop__s
opahs105411983_opahs
opals75718353_opals
opens76118553_opens
opes65942613_op_es
opium92812093_opium
opiums10307073_opiums
ops56641253_op__s
opts68124743_op_ts
ouphes113614633ouphes
ouphs104311273ouph_s
pappus9408373pappus
peplus10138343peplus
phis95724903__phis
phut96925973__phut
phuts104613503__phuts
plus66324833__plus
poilus82210573poilus
pompous1338053pompous
poohs103915713pooh_s
popes95933813pop_es
popgun1145733popgun
popguns1234023popguns
poppas93710713poppas
pops86340953pop__s
porous84419473porous
pothos114214693pothos
poyous112911613poyous
prahus11458243prahus
pupus94614043pup_us
pus55547843__p_us
qoph185911943qoph__
raphes115117453raphes
raphis114014323raphis
rhus75114053__rhus
ropers84325903ropers
ropes75940063rop_es
roshis9311793roshis
sadhus10298463sadhus
scyphus1743203scyphus
soleus64615613soleus
solus54726983so_lus
soph97024203soph__
sophies12314603sophies
sophism1437853sophism
sophist12311553sophist
sophy136611763soph_y
sopors85215193sopors
sops65244563sop__s
sorus54527583so_rus
soths86218623soth_s
sous46947213so__us
staphs114411033staph_s
stopers94217363stopers
stopes84525893stop_es
stops74827283stop__s
strophes13310593strophes
syphs13519453syph_s
tabus74820923t_abus
taches114224173taches
tachs105820933tach_s
tahrs85412333t_ahrs
talus55423263t_alus
tapas74627713tap_as
tapers84025813tapers
tapes75838603tap_es
taphouse1346333taphouse
tapirs84113173tapirs
tapis75028863tap_is
taps66050673tap__s
tarsus6310513tarsus
taus46342733t__aus
taxus125512483t_axus
techs106915833tech_s
tendus75111183tendus
teopans939203teopans
tepals85415043tepals
tepas76521683tep_as
tepees84215243tepees
tephra1136483tephra
tephras1236283tephras
tepoys1137543tepoys
teths85418513teth_s
this76027383t__his
thous86017253t_hous
thud85613913t__hud
thuds95110133t__huds
thug86415483t__hug
thugs95611993t__hugs
thymus14324733thymus
tights104015853tights
tipis76019923tip_is
tips66436763tip__s
tithes94720213tithes
toads65621063to_ads
toasts65914993toasts
tobies84521013tobies
tocher114014913tocher
tochers123413093tochers
todays10458103todays
todies74223553todies
tods56141843to__ds
toeas55726423to_eas
toes46956443to__es
toffs116016723to_ffs
tofts84919243to_fts
tofu76921333to_fu_
togas67823003to_gas
togs57242433to__gs
togue64816303to_gue
togues76014243togues
toiles63923513toiles
toils54527493to_ils
toits55327473to_its
tokays13397773tokays
tokens104711563tokens
tokers104818893tokers
tokes95234973to_kes
tolans64319273tolans
tolars64817923tolars
tolas54532773to_las
toles55147133to_les
tolls54728433to_lls
tolu45529153to_lu_
tolyls9436963tolyls
tomans85419133tomans
tombs97818733to_mbs
tomes76037383to_mes
toms68343493to__ms
tondos75115913tondos
toners64128003toners
tones56048663to_nes
tongas74315513tongas
tongs65928463to_ngs
tongue7410093tongue
tongues879693tongues
tonics83617863tonics
tonnes65320853tonnes
tons46553053to__ns
tools55325243to_ols
toons55027533to_ons
tooths96013803tooths
toots55331873to_ots
top510560683top___
topaz16315323top_az
topazes1857313topazes
tope65946383top__e
toped85631313top_ed
topee76029953top_ee
toper75231023top_er
topfull1244153topfull
topi67830393top__i
topic95721503top_ic
toping94122993toping
topless92511123topless
topmast1138123topmast
topmost1148173topmost
topo66932403top__o
topoi76018353top_oi
topped114617723topped
topper103817603topper
toppers113914603toppers
topple104411323topple
topples113111653topples
toque145113093to_que
toques154612353toques
torahs95115643torahs
toras55540373to_ras
torches123715433torches
torcs75123763to_rcs
tores55352673to_res
torics85118353torics
tories65435883tories
toros54336193to_ros
torpids1037373torpids
torpors939373torpors
torque15237673torque
torques16217513torques
torrs53923563to_rrs
tors46157383to__rs
torses64727953torses
torsks10549123torsks
torsos64815733torsos
tortas64918253tortas
tortes64826053tortes
torts56138123to_rts
tosh74826813tosh__
toss45637973to__ss
tosses65225393tosses
tossup875293tossup
tossups964013tossups
totals63115163totals
totems86810763totems
toters65026363toters
totes55139683to_tes
tother94117143tother
tots46654123to__ts
touches125118343touches
touchup1443833touchup
touchups1543063touchups
toughs105414983toughs
toupees938513toupees
tour45530373to__ur
tours55325863to_urs
touse55430673to__use
touses64229673touses
tout46753823to__ut
touts54830393to_uts
towels94314643towels
towers94423673towers
towhee122613883towhee
towhees13277793towhees
towies93521193towies
towns86018883to_wns
tows78545553to__ws
toxics153910203toxics
toxins133314283toxins
toyers95516333toyers
toyons95512123toyons
toyos87519143to_yos
toys78036343to__ys
tragus749223tragus
troches123715343troches
troilus736403troilus
tropes84824353trop_es
trophic14311033trophic
trophies13413673trophies
trophy1438283troph_y
tropics113610643tropics
tropins93116303tropins
troths95414153troth_s
tuchun1145443tuchun
tuchuns1233983tuchuns
tupiks1235493tupiks
tups65628763tup__s
tushes94319473tushes
tutus55214813t_utus
types105721063typ_es
typhon1436673typhon
typhons1537083typhons
typhose1546693typhose
typhuses1643763typhuses
typos106015813typ_os
typps12549303typ_ps
tythes12419703tythes
utopias9117723utopias
vodous1038593vodous
wops96634153wop__s
yodhs12669013yodh_s
yoghs125410593yogh_s
yous76230653yo__us

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 Limit1127163845.20321663.7
3Display Results3843840.1233122.0
 (SQL Overall)1786913845.46632691.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.