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

188 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
dismiss103815(None) 
desmids1166602desmids
diamins10312212diamins
discuss10357952discuss
dismals102010242dismals
dismast10311232dismast
dismasts1137512dismasts
dismays13237432dismays
dismes95617672dism_es
dismissal1252662dismissal
dismissed1344612dismissed
dismisses1245502dismisses
distils83015802distils
amiss75823073__amiss
biomass1155993biomass
cissies94116153cissies
cosmids1237633cosmids
cosmism1337013cosmism
cosmisms1446223cosmisms
cosmist11311333cosmist
cosmists1237993cosmists
daimios1035753daimios
daisies84217093dais_ies
dashis104414393dashi_s
dassies84418663dassies
deisms94411043deism__s
demies94825803d_emies
demise94618323d_emise
demises103719563d_emises
demits94918073d_emits
dermis94717163dermi_s
dermises112512023dermises
desist74818813des_ist
desists83611723des_ists
desmans1039003desmans
desmid1048363desmi_d
desmoids1244973desmoids
despise1038683despise
despises1139433despises
diacids1137863diacids
dialist8517763dialist
dialists9411413dialists
diamide1138473diamide
diamides1238823diamides
diamin9312523diami_n
diamine10311983diamine
diamines11311643diamines
diapirs10347643diapirs
diaries83321953diaries
diarist8517113diarist
diarists9410363diarists
diazins1739183diazins
dickies143416343dickies
didies84621833di_dies
diesis74013493diesi_s
digamies1238643digamies
digamist1248213digamist
digamists1345003digamists
digits84114533di_gits
digress938323digress
dikdiks1242563dikdiks
dillies84122163dillies
dimers94321093di_mers
dimes85833043di_m_es
dimity12310473di_mity
dimmers123811563dimmers
dimmest1249253dimmest
dimming13339593dimming
dimness1038843dimness
dims75435023di_m__s
dimwits1344513dimwits
dingies93618243dingies
dinkies123716033dinkies
dioxids1655683dioxids
dioxins1568003dioxins
dipshits1445263dipshits
dirties83119383dirties
disarms1039043disarms
disbars10310323disbars
disbuds11125243disbuds
discase102912863discase
discases112014503discases
disci85815023disci__
discing113914593discing
discoids1239873discoids
discos94915213dis_cos
discs85316263dis__cs
discus94512113dis_cus
discuses113112863discuses
disdains1037913disdains
disease83213843disease
diseases92415813diseases
diseurs839403diseurs
diseuse83110723diseuse
diseuses93112763diseuses
disguise1046833disguise
disguises1146873disguises
disgust937633disgust
disgusts1045653disgusts
dishes104622653dis_hes
dishier113613403dishier
dishiest12313683dishiest
dishing124017103dishing
disjoins1647623disjoins
disking134615493disking
disks105417473dis__ks
dislike122913453dislike
dislikes132810843dislikes
dislimn1056103dislimn
dislimns1144813dislimns
dismal92412243dism_al
dismay12229473dism_ay
disme85716243dism__e
dismissals1352203dismissals
dismissing1445063dismissing
dismission1354363dismission
dismissive1652973dismissive
disomic1238763disomi_c
disowns1136733disowns
dispels10310503dispels
dispose10312763dispose
disposes11313823disposes
diss56434483d___iss
disseise939853disseise
disseises1039333disseises
disses75225963dis_ses
dissing94517683dissing
distains9413603distains
distich13312173distich
distichs1447633distichs
distil73616433disti_l
distill83011323distill
distills9319043distills
distress9311713distress
disuse74012843dis_use
disuses84015413disuses
ditties83116983ditties
divvies1457663divvies
dixits144210313di_xits
dizzies16279753dizzies
dormins10311273dormins
dossils8669773dossils
dummies123012133dummies
duskish1535183duskish
filmis114610283filmi_s
gimmies123010113gimmies
gismos957183gism_os
hissies103915823hissies
imids86015143_i_mids
immies102412443_immies
isms66213473_ism__s
jasmins1637083jasmins
jimmies18328783jimmies
jisms14458003jism__s
kirmess13234313kirmess
kismats13257843kismats
kismets13306883kismets
koumiss1344313koumiss
kumiss1235923_kumiss
limits82514143li_mits
mimics1289363mi_mics
misaims11310113misaims
misbias1139083misbias
misfits12279663misfits
mishits122513083mishits
mislies92922283mislies
miss65339423___miss
missies93423983missies
missis84417503missi_s
missises103513693missises
niseis63512023nisei_s
osmics1036463_osmics
pigmies122610993pigmies
pismire1135353pismire
pismires1235883pismires
pistils93314303pistils
premiss113513813premiss
remiss84216353_remiss
rishis9312453rishi_s
seismism1243733seismism
seismisms1343233seismisms
siskins1159583siskins
sissies73716603sissies
submiss1138083submiss
swiss86712903__swiss
visits9311423vis_its
wiseass1035823wiseass
wispish1575643wispish

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.1561145455.1
2DLD Change Limit1340271886.83019623.3
3Display Results1881880.0632984.1
 (SQL Overall)1786911887.04925349.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.