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

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

111 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
compensational207352(None) 
compensation18126502compensation__
compensations19136182compensation_s
condensational1753642condensational
combinational1984073combin_ational
compensating1955003compensati_n_g
compositional1974043comp_ositional
computational1994573comp_utational
conversational1954153conversational
dispensational1762503dispensational
nonsensational1463273nonsensational
commendation1946514commendation__
commendations2055804commendation_s
communicational2383064communicational
compellation1855104compellation__
compellations1954804compellation_s
compensative2154654compensati__ve
compensator1754674compensat_o__r
compensators1854374compensat_o_rs
compensatory2163644compensat_o_ry
compressional1954254compres_sional
condensation1546784condensation__
condensations1646274condensation_s
conservational1955334conservational
conventional1757154conven__tional
correlational15113674corre_lational
decompensation2193364decompensation__
decompensations22103044decompensation_s
operational1347514_o_pe_rational
orientational1353794_orientational
sensational1146384___sensational
unsensational1353664_unsensational
cementation1559705cem_entation__
cementations1659015cem_entation_s
coeducational1853295co_educational
cognitional1454265co__gn_itional
collocational1753055co_llocational
combination17108805combin_ation__
combinations1897915combin_ation_s
commensuration20162985commensuration__
commensurations21182585commensuration_s
commentating1957045commentati_n_g
commination171111645commin_ation__
comminations18810485commin_ation_s
compensability2563525compensability
compensate1646145compensat____e
compensated1844865compensat___ed
compensates1745725compensat___es
competition1755775compe_tition__
competitions1845535compe_tition_s
compilation1749315comp_ilation__
compilations1848675comp_ilation_s
complexation25144245complexation__
complexations26134015complexation_s
complexional2551965comp__lexional
complication2048205complication__
complications2147435complication_s
componential1863075componenti__al
composition1746795comp_osition__
compositionally2462285comp_ositionally
compositions1846255comp_osition_s
compunction19115905compun_ction__
compunctions20145695compun_ction_s
compurgation19134185compurgation__
compurgations20123895compurgation_s
computation1748715comp_utation__
computationally2462495comp_utationally
computations1848125comp_utation_s
conceptional1856905conce__ptional
concessional16195395conce_s_sional
conditional1447105co___nditional
confessional17175465confe_s_sional
confirmational21153385confirmational
conformational21153705conformational
confrontational2071595confrontational
congregational1863425congregational
conjugational2353695co_njugational
conjunctional2454155conjun_ctional
connectional1646715co__nnectional
connotational1554155co_nnotational
consociational1853545consociational
conspirational1853955conspirational
convectional1947035conve__ctional
conversation1747805conversation__
conversations1847455conversation_s
conversional1755145convers__ional
convocational2054475co_nvocational
cooperation15410025coope_ration__
cooperations1659195coope_ration_s
correctional1675315corre__ctional
decompensating2262525decompensati_n_g
dimensional1453035dim_ens__ional
dispensation1555605dispensation__
dispensations1655485dispensation_s
documentational2061965documentational
expectational2452495_expectational
fomentation1647715fom_entation__
fomentations1746795fom_entation_s
foundational1652845fo__undational
hyperrational2153935_hyperrational
mediational1445635__m_ediational
nonnational11107835no___nnational
nonoperational1663765nonope_rational
nonrational11109115no___nrational
observational1853175_observational
oppositional1683835_o_ppositional
populational1654415po_p_ulational
presentational1673215presentational
recombinational21102025recombin_ational
speciational1654315__speciational
supernational1555615_supernational

Search took 8 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 Filter178691950240.1261418182.5
2DLD Change Limit950241117.34312940.8
3Display Results1111110.0801387.5
 (SQL Overall)1786911117.54923670.8
 
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.