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 “dismissions” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
dismissions145400(None) 
dismission1354361dismission_
demissions1345662d_emissions
discussions1444242discussions
dismissing1445062dismissi_ng
dispassions1453882dispassions
abscissions1552403abscissions
admissions1343463_admissions
commissions1745263commissions
demission1246033d_emission_
digressions1344743digressions
dimensions1344613di_mensions
discussion1344503discussion_
dismissals1352203dismiss_als
dismisses1245503dismiss__es
dismissive1652973dismissi_ve
dispassion1344323dispassion_
dispersions1446453dispersions
displosions14203833displosions
dissensions12175573dissensions
dissuasions1243523dissuasions
distensions12146273distensions
divisions1396283di_vi_sions
emissions1146923__emissions
missions10311903___missions
omissions1146153__omissions
permissions1545333permissions
reemissions1344153reemissions
remissions1246613_remissions
rescissions1344593rescissions
scissions1145433__scissions
submissions1553693submissions
abscission1452524abscission_
admission1243734_admission_
commission1645624commission_
decisions1248384d_eci_sions
decommissions2052854decommissions
depressions1447314depressions
derisions1038844d_eri_sions
descensions1444374descensions
diffusions1743734di_ffusions
digestions1246404di_gestions
digression1244664digression_
dimension1244744di_mension_
diminutions1444544di_minutions
discretions1447224discretions
discussing1445984discussi_ng
disillusions1352324disillusions
dismasting1446384dismasti_ng
dismiss1038154dismi_s___s
dismissal1252664dismiss__al
dismissed1344614dismiss__ed
dismissively2161954dismissively
dispersion1346864dispersion_
displosion13184494displosion_
dispositions1546474dispositions
disquisitions2353244disquisitions
disruptions14125684disruptions
dissections14198264dissections
disseisins1145954disseisi_ns
dissension11135724dissension_
dissentions12168044dissentions
dissipations1546534dissipations
dissuasion1143844dissuasion_
distension11156274distension_
distentions12178844distentions
distinctions1557324distinctions
distortions1246614distortions
disunions1055974dis__unions
diversions1446534di_versions
division1266684di_vi_sion_
divulsions1443344di_vulsions
dominions12126554d_omi_nions
emission1047674__emission_
fissions1138034___fissions
immersions1444004_immersions
impassions1444844_impassions
incisions1147354_inci_sions
manumissions1661504manumissions
misassigns1352414mis_assigns
misdivisions1851784misdivisions
misprisions1553154misprisions
mission9312744___mission_
obsessions1244274obs_essions
omission1046534__omission_
permission1445714permission_
possessions1265024possessions
readmissions1552734readmissions
reemission1244334reemission_
remission1147334_remission_
rescission1244864rescission_
resubmissions17112114resubmissions
scission1045564__scission_
sessions839724__s_essions
submission1453744submission_
transmissions1554124transmissions

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819968.70317099.7
3Display Results96960.0462087.0
 (SQL Overall)178691969.17219482.2
 
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.