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

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

80 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
commensalisms187375(None) 
commensalism1764951commensalism_
communalisms17144182commun_alisms
commensals1645673commensal___s
commercialisms21183663commercialisms
communalism16145223commun_alism_
communalists18134563commun_alists
colonialisms1674754co_lonialisms
commendams1644314commenda___ms
commendations2055804commendations
commensal1546024commensal____
commensally2054794commensal__ly
commentaries1856804commentari_es
commercialises22173814commercialises
commercialism20184184commercialism_
commercialists22183824commercialists
communalist17116254commun_alis_t
communalizes2754234commun_alizes
communisms1545004commun___isms
compensations19136184compensations
mentalisms1449314___mentalisms
nominalisms1555154no_min_alisms
orientalisms14105904_orientalisms
caesarisms1444905c__ae_sarisms
centralisms1547405c___entralisms
ceremonialisms20103205ceremonialisms
colonialism1565435co_lonialism_
colonialists1484995co_lonialists
commendam1544955commenda___m_
commendation1946515commendati_on
commensurations21182585commensurations
commentates17107615commenta__tes
commentating1957045commentati_ng
commentators1854795commenta_tors
commercialise21184165commercialis_e
commercialised23193015commercialised
commercialist21204685commercialis_t
commercializes31193785commercializes
comminations18810485commin_ations
commissariats1961355commissariats
commissaries1852885commissari_es
commonalities1965155common_alities
commonality2055535common_ali_ty
commonalties1854255common_alties
communalities1954845commun_alities
communality2055195commun_ali_ty
communalize2654735commun_ali_ze
communalized2853505commun_alized
communises1646565commun___ises
communism1445635commun___ism_
communists1646235commun___ists
compendiums2052175compen__diums
compensates1745725compensa__tes
compensating1955005compensati_ng
compensation18126505compensati_on
compensative2154655compensati_ve
compensators1854375compensa_tors
conceptualisms22133815conceptualisms
condensations1646275condensations
connubialisms1971685connubialisms
conservatisms2083535conservatisms
credentialisms1963175credentialisms
documentalists19153955documentalists
ecumenicalisms22101925ecumenicalisms
formalisms17227245form___alisms
immoralisms1454635_imm_oralisms
imperialisms18105905_imperialisms
incrementalisms21173685incrementalisms
journalisms2053475jo_urn_alisms
maenadisms1543485__maen_adisms
mentalism13511645___mentalism_
mentalists12410485___mentalists
nominalism1446135no_min_alism_
nominalists1355735no_min_alists
orientalism13126495_orientalism_
orientalists12125775_orientalists
sacramentalisms2173335sacramentalisms
sensualisms1353875___sensualisms
symmetallisms1961555symmetallisms
universalisms1872745universalisms

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 Filter1786911247900.406440125.6
2DLD Change Limit124790808.87314064.0
3Display Results80800.0461739.1
 (SQL Overall)178691809.32519162.6
 
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.