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

109 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
heroisms133869(None) 
heroism12311011heroism_
egoisms1065952_egoisms
erotisms10310162_erotisms
hedonisms1545602hedonisms
helotisms1446832helotisms
heroics122912002heroi_cs
heroines112916572heroines
heroinisms1546622heroinisms
heroins103518012heroi_ns
heroizes202610982heroizes
hoboisms1545562hoboisms
verisms123011252ver_isms
acrotisms1347493acrotisms
atropisms1347103atropisms
bromisms1436403_bromisms
cercises12410933cercises
cerises94722253cer_ises
ceriums1139473cer_iums
charisms15710263char_isms
chemisms17278213che_misms
chrisms1499143chr_isms
deisms94411043de__isms
demonisms1448053demonisms
dermises112512023dermises
derrises93012783derrises
dodoisms1244523dodoisms
echoisms1546143echoisms
egoism977473_egoism_
egoists887073_egoists
egotisms1146683_egotisms
eonisms92811043_eonisms
erbiums1135463_erbiums
ergotisms1245303_ergotisms
eroses65327053_ero_ses
erotism9312293_erotism_
exotisms1746723_exotisms
fermiums1544353fermiums
genoises939253genoises
harpists1338093harpists
hedonism1446443hedonism_
hedonists1346053hedonists
heists96814633he__ists
heliums12188303he_liums
helotism1347693helotism_
herbalisms1746283herbalisms
herdics13249523herdi_cs
heresies11312693heresies
heriots10312063her_iots
hermetisms1745613hermetisms
hermitisms1745603hermitisms
hermits12312133hermi_ts
herms105626433her___ms
hernias10310773herni_as
heroes94923823hero__es
heroic113516923heroi__c
heroical13410013heroical
heroin94420593heroi__n
heroine103517483heroi_ne
heroinism1446873heroinism
heroize193210963heroi_ze
heroized21298443heroized
herons94820543hero__ns
heros84930863hero___s
herries104025073herri_es
herrings12379523herrings
hexoses17228883hexo_ses
hoboism1446613hoboism_
hoises94823673h__oises
hoists95516023h__oists
holisms123811113h_olisms
hornists11208833hornists
kermises14248313kermises
leftisms13235243leftisms
locoisms1256143locoisms
lyrisms1235653lyr_isms
merises93421423mer_ises
merisis93213173mer_isis
moronisms1348173moronisms
narcisms1267263narcisms
nepotisms1355393nepotisms
ogreisms1144113ogreisms
ogrisms1036443ogr_isms
peonisms1238443peonisms
persists1049183persists
porisms113713453por_isms
prisms104915503_pr_isms
purisms114110833pur_isms
realisms102212163realisms
reraises8415633reraises
rerises73525883rer_ises
seisms84912143se__isms
serosas7312663sero_sas
sexisms16226223se_xisms
sherrises12156863sherrises
teratisms11410063teratisms
terbiums1245423terbiums
terrorisms12125823terrorisms
theisms1237763the__isms
theorises1247813theorises
theorists1246593theorists
tropisms1247723_tropisms
truisms9106823_truisms
verism113214263ver_ism_
verismo12276393ver_ismo
verismos13284693ver_ismos
verists103613673ver_ists
xeroses143612823xero_ses
xerosis14249663xero_sis

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.1701051123.5
2DLD Change Limit1461621098.73616731.0
3Display Results1091090.0303633.3
 (SQL Overall)1786911098.93619996.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.