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

233 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
misusers1034807(None) 
misuser93210441misuser_
misuses93216021misuse_s
disuses84015402disuse_s
hissers104112312his_sers
issuers746122_issuers
kissers114211292kis_sers
minuses93512702minuse_s
misavers1348052misavers
misdoers1137102misdoers
misers85025702mi__sers
missels94614812mis_sels
misses85130872mis_se_s
missets94516572mis_sets
missuses10309682missuse_s
misters93927502mis_ters
misuse83213642misuse__
misused104111272misuse_d
mossers94116192mos_sers
mousers95216442m_ousers
musers84719092m__users
pissers95014752pis_sers
risuses73210922risuse_s
abusers94710553_abusers
accusers12285903accusers
amassers10337833amas_sers
amusers94610193_amusers
arousers84810973arousers
assumers1064963assumers
assurers866303assurers
bisters93922603bis_ters
causers94014783_causers
chousers134610183chousers
cistuses1038283cistuse_s
cussers94213393cus_sers
defusers12487363defusers
diffusers1642773diffusers
diluters9288103diluters
disasters1039143disasters
disbursers1373863disbursers
discuses113112853discuse_s
discussers13235183discussers
diseuses93112753diseuse_s
disguisers1244013disguisers
disposers1238363disposers
disputers1236603disputers
dissert83720693dis_sert
disserts92411813dis_serts
disses75225963dis_se_s
disuse74012833disuse__
disused93211013disuse_d
dossers84516233dos_sers
dousers84817273_dousers
ensurers8279373ensurers
excusers1734443excusers
ficuses12159203ficuse_s
figurers12254863figurers
fishers134714723fis_hers
fissures1136573fissures
focusers13134373focusers
fussers104210813fus_sers
gassers84714633gas_sers
grousers93810723grousers
hisser94713793his_ser_
hisses94719353his_se_s
housers104717813_housers
imposers12278453imposers
imputers1235813imputers
infusers11286143infusers
insurers83710133insurers
isomers9310043_isomers
isseis638563_is_seis
issuer646623_issuer_
issues648803_issue_s
kisser104212453kis_ser_
kisses104217333kis_se_s
lispers94514323lis_pers
listers74026523lis_ters
lususes736713lususe_s
manurers1037593manurers
masers84623453m__asers
mashers124621053mas_hers
maskers133913833mas_kers
masquers19195703masquers
masses85028713mas_se_s
masseurs1034923mas_seurs
masters94628923mas_ters
maturers1037373maturers
maulers94213303m_aulers
measurers1144883measurers
meisters103313843meis_ters
messes84924343mes_se_s
middlers123410193middlers
midsummers1451383midsummers
milers84625163mi__lers
milkers134411613mi_lkers
millers93621333mi_llers
milliers102611893milliers
milters93619083mi_lters
mimers105520183mi__mers
mimeses1139073mimese_s
mincers113714843mi_ncers
minders103720113mi_nders
mindsets1135683mindsets
miners84126633mi__ners
minglers113011283minglers
ministers1139613ministers
minivers1337473minivers
minsters103813913minsters
minters93822463mi_nters
minuets9259853minu_ets
minuter93510403minuter_
minutes93513433minute_s
mioses84318853mi_ose_s
misalters1136903misalters
misaver1249813misaver_
miscues11312393miscue_s
misdeeds12276813misdeeds
misdeems13255653misdeems
misdoer1048633misdoer_
misdoes10312493misdoe_s
miseases102614343misease_s
misenters1139523misenters
miser75430403mi__ser_
miserere1049273miserere
misereres1148183misereres
misery114113543mi__sery
mises74740563mi__se_s
misfeeds14315623misfeeds
misfires132210583misfires
misguess1134643misguess
misguiders14133303misguiders
mishears1338323mishears
misinfers1445473misinfers
misinters1138163misinters
miskeeps1644163miskeeps
mislayers1445933mislayers
mislies92922283mislie_s
mislikers15317053mislikers
mismeets12297733mismeets
misnomers1346183misnomers
misnumbers1642223misnumbers
misorders1245863misorders
mispens11311073mis_pens
misquoters2142623misquoters
misrefers1445363misrefers
misrules1039383misrule_s
missals93914423mis_sals
missays124010253mis_says
misseat93617233mis_seat
misseats104011683mis_seats
missed94423603mis_se_d
missel85216523mis_se_l
missend104411373mis_send
missends11368233mis_sends
missense1037963mis_sense
missent94318713mis_sent
misset85028153mis_se_t
missies93423983mis_sies
missis84417503mis_s_is
missises103513693missise_s
missort9314653mis_sort
missorts1038323mis_sorts
missteers1135913missteers
missteps12156143missteps
missuits1078023missuits
missus85312293mis_s_us
mistakers15117073mistakers
mister84728563mis_ter_
misterm114314513mis_term
misterms123711333mis_terms
mistier93418713mistier_
mistress10310703mistress
mistunes10311133mistune_s
mistutors1144763mistutors
misusage1145173misusage
misusages1244973misusages
misusing1138893misusing
miterers10219683miterers
miters84328773mi__ters
mithers123516733mi_thers
mitises9315543mitise_s
mitoses9312183mitose_s
mixers154513563mi__xers
momsers113810843m_omsers
momuses1159263momuse_s
moshers124017843mos_hers
mosser84618273mos_ser_
mosses85527683mos_se_s
mouser85822443m_ouser_
mouses85531423m_ouse_s
mousses94012703mousse_s
mucuses11148513mucuse_s
muser76024123m__user_
muses75134303m__use_s
mushers124016433mus_hers
mussels9419843mus_sels
musses84624783mus_se_s
musters94522493mus_ters
niduses837013niduse_s
nonusers8268003nonusers
passers94717753pas_sers
pausers94113223_pausers
perusers10328803perusers
pishers123815753pis_hers
pisser84416383pis_ser_
pisses84525083pis_se_s
refusers11499273refusers
reissuers954033reissuers
resumers1038083resumers
rinsers73815743ri_nsers
risers64624783ri__sers
riskers114011993ris_kers
rousers75220133_rousers
sinuses73011593sinuse_s
sisses64520603sis_se_s
sisters73721573sis_ters
situses72710493situse_s
subers85722643__subers
sudsers83310413__sudsers
suers55128483__su_ers
supers84622403__supers
tissues737463tissue_s
tossers74713493tos_sers
trousers83910623trousers
trussers8348263trussers
tussers74313563tus_sers
users55817573___users
usurers766363_usurers
viruses1039413viruse_s
visiters1137403visiters
wishers133215213wis_hers
wisses94619603wis_se_s

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622337.81318707.5
3Display Results2332330.1731346.8
 (SQL Overall)1786912338.14221946.8
 
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.