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

75 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
commensurations2118258(None) 
commensuration20162981commensuration_
commemorations1953443comme_morations
commendations2055803commen__dations
commiserations2053453comm_iserations
compensations19136183compens__ations
mensurations1445713___mensurations
cogenerations1655914co_gen_erations
commemoration1853884comme_moration_
commendation1946514commen__dation_
commensurate1853024commensurat___e
commensurately2361744commensurat_ely
comminations18810484commin___ations
comminutions1894314commin_u__tions
commiseration1964044comm_iseration_
communications22105754commun_ications
communizations29126104commun_izations
commutations1847264comm___utations
compensation18126504compens__ation_
concentrations1877074concen_trations
condensations1646274condens__ations
conjurations2148494co___njurations
mensuration1346494___mensuration_
cementations1659015c_emen__tations
coeducations1745875co__e_ducations
cogeneration1546445co_gen_eration_
combinations1897925combin___ations
commemorating1953075comme_morati_ng
commemoratives2262425comme_moratives
commemorators1862455comme_morat_ors
commensalisms1873755commens__alisms
commensurable2162295commensura__ble
commensurably2462095commensura__bly
commentating1957045commen__tati_ng
commentators1854795commen__tat_ors
commination171111645commin___ation_
comminution17105015commin_u__tion_
commiserating2053195comm_iserati_ng
communication21106215commun_ication_
communization28116685commun_ization_
commutation1748005comm___utation_
compellations1954815compe__llations
compensating1955005compens__ati_ng
compensational2073525compens__ational
compensators1854375compens__at_ors
compurgations20123895co_m__purgations
computations1848125co_m__putations
concelebrations21103165concelebrations
concentration1758015concen_tration_
condensation1546785condens__ation_
confederations20104605confe_derations
configurations2063705co_nfigurations
confutations1767795co___nfutations
conjugations2245865co___njugations
conjuration2049515co___njuration_
consecrations1749215co___nsecrations
conservations1849095co___nservations
consolations1449745co___nsolations
conspirations1747725co___nspirations
consultations1546935co___nsultations
consummations1955155co___nsummations
consumptions1845145co___nsumptions
contestations1547735conte_s_tations
continuations1547145contin_u_ations
conurbations1646665co___n_urbations
conversations1847455convers__ations
cooperations1659195coope___rations
crenulations1446495c__ren_ulations
decompensations22103045decompens__ations
demonstrations1795675_demonstrations
fomentations1746795fo_men__tations
menstruations1585055___menstruations
mercurations1646565___mercurations
recommendations22113095recommen__dations
remonstrations16116485_remonstrations

Search took 5 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 Filter178691658740.313570897.8
2DLD Change Limit65874754.14015911.6
3Display Results75750.0461630.4
 (SQL Overall)178691754.49939717.9
 
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.