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

138 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
premisses1328876(None) 
premises123018271premi_ses
pelisses1048482p_elisses
precesses13310462precesses
precises123218332preci_ses
premieres13288232premieres
premies113823062premi__es
premise113818552premi_se_
premised133013192premi_sed
premiss113513812premi_s_s
premixes193110082premi_xes
prerinses1138812prerinses
presses93523152pre__sses
previses133814282previ_ses
prisses94816712pr__isses
promisees13246862promisees
promises122916762promi_ses
remises93423482_remi_ses
bekisses1434243_bekisses
blemishes1665083blemishes
brewises1337213brewi_ses
brisses94314313br__isses
chemises153211983chemi_ses
cresses94219813cre__sses
crevasses1444133crevasses
demises103719563_demi_ses
dermises112512023dermi_ses
dismisses1245493dismisses
dresses83716173dre__sses
eremites10312593eremi_tes
flemishes1765243flemishes
fremituses1542973fremituses
gneisses933673gne_isses
itemises1087693itemi_ses
kermesses15284963kermesses
kermises14248313kermi_ses
koumisses1552123koumisses
kumisses1443583_kumisses
metisses1036833_metisses
misses85130873___misses
pavisses13397103p_avisses
peeresses1138453peeresses
peises84125043p_e_i_ses
pelisse967063p_elisse_
penises9318193p_eni_ses
percusses1346503percusses
perishes13313753p_erishes
permeases1347093permeases
pertusses1145383pertusses
pisses84525083p___isses
plenishes1487083plenishes
plisses94411773p__lisses
poetesses1137233poetesses
poetises10313953poeti_ses
praises94121103pr_ai_ses
praxises1739063praxi_ses
preblesses1445103preblesses
precessed1437523precessed
preciouses1446883preciouses
precipes143212213preci_pes
precise113518173preci_se_
precised133213413preci_sed
preciser123411663preci_ser
precisest13259003precisest
predisposes1653453predisposes
preemies12512193preemi__es
prefiles133113443prefi_les
prefires134313283prefi_res
prefixes20389233prefi_xes
preimposes1644033preimposes
prelives13310383preli_ves
premie103617993premi__e_
premier113515633premi__er
premiere12249233premiere_
premiered14237083premiered
premiers122911653premi_ers
premising14412413premising
premiums1437533premi_ums
premixed20338003premi_xed
premoisten14124113premoisten
premoistens15122893premoistens
premonishes1843913premonishes
premorse1237553premorse_
prepastes13128823prepastes
prepossess1443073prepossess
prerinse1038633prerinse_
prerinsed1246323prerinsed
presides11414913presi_des
pressed103317303pre__ssed
presser93717623pre__sser
pressers103215023pre__ssers
pretastes11119423pretastes
pretenses112210583pretenses
previse123713793previ_se_
prevised143611073previ_sed
previsits1446793previsits
previsors14126483previsors
prewashes1744753prewashes
prewires133811013prewi_res
prexies163415003prexi__es
primines123013703primi_nes
primnesses1497803primnesses
primroses1344843primroses
primuses1237083prim_uses
prises84133173pr__i_ses
prissed103311263pr__issed
prissies101712003pr__issies
processes13310233processes
professes1437873professes
promines123018803promi_nes
promise113415843promi_se_
promised133010873promi_sed
promisee122711333promi_see
promiser122510673promi_ser
promisers13268203promisers
promisors13236353promisors
prosses94019513pr__osses
provisoes1446653provisoes
prowesses1437193prowesses
purenesses12810723purenesses
recesses10312323_recesses
reissues845993_re_issues
relishes11311953_relishes
remiges103015473_remi_ges
remise84221953_remi_se_
remised103516843_remi_sed
remiss84216353_remi_s_s
remissly1344593_remissly
remissness1244213_remissness
remixes164313873_remi_xes
remorses10311993_remorses
repasses101810373_repasses
rerises73525883_reri_ses
revises104220533_revi_ses
semioses10611013_semioses
semises93916553_semi_ses
speisses10245693spe_isses
tresses73719543tre__sses

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411388.82616841.3
3Display Results1381380.0632190.5
 (SQL Overall)1786911389.06219718.7
 
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.