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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
fusionisms154399(None) 
fusionism1444601fusionism_
fusionists1354471fusionists
fusionist1246072fusionis_t
unionisms1145882_unionisms
diffusionisms2281883diffusionisms
feminisms16217683femi_nisms
fusions1039153fusion___s
illusionisms1452923illusionisms
luminisms1346543lumi_nisms
unionises947163_unionises
unionism1047013_unionism_
unionists946213_unionists
actinisms1398884acti_nisms
albinisms1395774albi_nisms
alienisms1146704_alienisms
alpinisms1375974alpi_nisms
arsonists947414ars_onists
bourbonisms1751884bourbonisms
business102110694busi_nes_s
clonisms1237794__clonisms
customises1444804customises
cutinises1148514cuti_nises
daltonisms1345164daltonisms
demonisms1448054_demonisms
despotisms1543144despotisms
diffusionism2182094diffusionism_
diffusionists2082264diffusionists
divisionisms1862774divisionisms
eonisms92811044___eonisms
epigonisms1544084epigonisms
eudaimonisms17131874eudaimonisms
euphoniums17123204euphoniums
fairyisms1743074f_airyisms
familisms1645864fami_lisms
fascisms1545664fas__cisms
fashionista1761934fashionista
fashionistas1871164fashionistas
feminises14229754femi_nises
feminism15198484femi_nism_
feminists14227624femi_nists
fetichisms2043464fetichisms
fetishisms1852484fetishisms
fictionists1655994fictionists
fideisms1444454f__ideisms
finises10312904f__i_nises
foreignisms1752194foreignisms
fusiliers1243714fusi_liers
fusillis1143564fusilli__s
fusion939774fusion____
fusional1145074fusion__al
fussiness12226584fussines_s
fustiness121910244fustines_s
futurisms1444534fu_turisms
hedonisms1545604_hedonisms
heroinisms1546634heroinisms
hispanisms1753244hispanisms
humanisms1646684hu_manisms
idiotisms1244204_idiotisms
illusionism1353514illusionism_
illusionists1253674illusionists
iodisms10308484___iodisms
ionises72916434___ionises
ioniums938304___ioniums
laconisms1347014_laconisms
lesbianisms1552534lesbianisms
lionises8310314__lionises
luminism1247354lumi_nism_
luminists1147174lumi_nists
mammonisms1254224mammonisms
meliorisms1445554meliorisms
messianisms1553394messianisms
misoneisms1443474mis_oneisms
monisms113512804___monisms
moronisms1348174_moronisms
muoniums1244724mu__oniums
padronisms1544884padronisms
peonisms1238444__peonisms
perfusionists1863114perfusionists
pianisms1249014__pianisms
platonisms1466334platonisms
plutonisms1485044plutonisms
pugilisms14124094pugi_lisms
puritanisms1554214puritanisms
quietisms2064024qu_ietisms
quixotisms2851794quixotisms
reunionists1154564reunionists
revisionisms17143864revisionisms
routinisms1245774routi_nisms
ruffianisms1951684ruffianisms
sciolisms1346224_sciolisms
simonists1146764__simonists
sulfoniums1552904sulfoniums
tectonisms1445574tectonisms
unionise847864_unionis_e
unionised1046534_unionised
unionist8410354_unionis_t
unionizes1846114_unionizes
uranisms1099974_u_ranisms
urbanisms13115994_urbanisms
utopisms1245414_u_topisms
vulcanisms1753624vulcanisms

Search took 12 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 Filter1786911614500.420425454.8
2DLD Change Limit16145010211.40614154.8
3Display Results1021020.0462217.4
 (SQL Overall)17869110211.87215051.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.