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

100 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
dispassions145388(None) 
dispassion1344321dispassion_
discussions1444242discussions
dismissions1454002dismissions
dispersions1446452dispersions
displosions14203832displosions
impassions1444842_impassions
compassions1745773compassions
diapasons1243203diapa_s_ons
digressions1344743digressions
discussion1344503discussion_
dismission1354363dismission_
dispassionate1662173dispassionate
dispersion1346863dispersion_
displosion13184493displosion_
dispositions1546473dispositions
dissensions12175573dissensions
dissuasions1243523dissuasions
distensions12146273distensions
impassion1344863_impassion_
misassigns1352413mis_assigns
misprisions1553153misprisions
passions10310583___passions
abscissions1552404abscissions
aspersions1246104_aspersions
assassins843934_assassi_ns
compassion1645984compassion_
demissions1345664d_emissions
depressions1447314depressions
descensions1444374descensions
diapason1143624diapa_s_on_
diapausing1442874diapausi_ng
dictations1389704dicta_tions
diffusions1743734di_ffusions
digestions1246404di_gestions
digression1244664digression_
dilations102614454di_la_tions
dimensions1344614di_mensions
disastrous1153074dis_astrous
discasing1339434disca_si_ng
discretions1447224discretions
discussing1445984discussi_ng
disdains1037914disda__i_ns
diseasing11310834disea_si_ng
disillusions1352324disillusions
dismasting1446384dismasti_ng
dismissing1445064dismissi_ng
disparting1438934disparti_ng
dispensations1655484dispensations
dispensing1448234dispensi_ng
dispersing1449304dispersi_ng
dispersoids1553014dispersoids
disposing1339934disp_osi_ng
disposition1446684disposition_
dispossess1243394disposs_ess
dispossessions1561494dispossessions
dispraising1546044dispraisi_ng
disputations15106174disputations
disruptions14125684disruptions
dissections14198264dissections
disseisins1145954disseisi_ns
dissension11135724dissension_
dissentions12168044dissentions
dissipations1546534dissipa_tions
dissuasion1143844dissuasion_
distains9413604dista__i_ns
distasting1248024distasti_ng
distension11156274distension_
distentions12178844distentions
distortions1246614distortions
distractions1548754distractions
disunions1055974dis__unions
diversions1446534di_versions
divisions1396284di__visions
divulsions1443344di_vulsions
expansions1944154_expansions
fissions1138034fi___ssions
impactions1645414_impactions
impassioned1652934_impassioned
implosions1444024_implosions
impressions1546824_impressions
impulsions1443604_impulsions
invasions12115414_inva_sions
misassign1243224mis_assign_
miscaptions1744184miscaptions
misparsing1546614misparsi_ng
mispositions1655304mispositions
misprision1453504misprision_
missions10311904mi___ssions
obsessions1244274obs_essions
passion9310884___passion_
possessions1265024possessions
rescissions1344594rescissions
responsions1363774responsions
scansions1145324__scansions
scissions1145434__scissions
sessions839724__s_essions
sponsions1145224__sponsions
suasions838784__sua_sions
suspensions1353844suspensions

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 Filter1786911488190.420425454.8
2DLD Change Limit1488191008.40617703.9
3Display Results1001000.0631587.3
 (SQL Overall)1786911008.88920102.5
 
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.