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

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

87 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
compurgations2012389(None) 
compurgation19134181compurgation_
compurgators19102942compurgat_ors
computations1848122compu_tations
commutations1847263commu_tations
compellations1954813compellations
compensations19136183compensations
compilations1848683comp_ilations
complexations26134013complexations
complications2147433complications
compunctions20145693compu_nctions
compurgator1882823compurgat_o_r
computation1748713compu_tation_
conjugations2245863conju_gations
conjurations2148493conjur_ations
conurbations1646663co_nurbations
cooperations1659193cooper_ations
copulations151111113co_pu_lations
corporations16129483corpor_ations
corrugations1565483corru_gations
expurgations2274123_expurgations
objurgations2252233_objurgations
purgations1346743___purgations
amputations1546444_ampu_tations
coacervations2053874coacervations
coagulations1546514coagu_lations
coaptations1547544coap__tations
coeducations1745874coedu_cations
colligations1556834co_lligations
colorations13911894co_lor_ations
combinations1897924com_binations
combustions1744534combu__stions
commendations2055804commendations
comminations18810484com_minations
communications22105754communications
communizations29126104communizations
commutation1748004commu_tation_
compactions1946544comp__actions
companions1697264comp___anions
comparatists1853734compar_atists
comparatives21164854compar_atives
comparators1785684compar_at_ors
compellation1855104compellation_
compensation18126504compensation_
competitions1845534comp_etitions
compilation1749314comp_ilation_
completions1746914comp__letions
complexation25144244complexation_
complication2048204complication_
compositions1846254comp_ositions
compressions1856404comp_ressions
compulsions1744594compu__lsions
compunction19115904compu_nction_
compunctious20143034compu_nctious
computational1994574compu_tational
confirmations2055674confirmations
conformations2046724conformations
confutations1767794confu_tations
congregations17186414congregations
conjugation2146624conju_gation_
conjuration2049514conjur_ation_
conservations1849094conservations
conspirations1747724conspir_ations
consultations1546934consultations
consummations1955154consummations
conurbation1547464co_nurbation_
conversations1847454conversations
cooperation15410024cooper_ation_
copulation141111954co_pu_lation_
corporation151210654corpor_ation_
corrugation1445994corru_gation_
coruscations1645244co_ruscations
covariations1745984co_variations
cumulations1547434cum_u_lations
expurgation2154554_expurgation_
homologations19102354homologations
impartations16135434_impartations
importations16156144_importations
imputations1546354_impu_tations
objurgation2152404_objurgation_
obturations13116424_obtur_ations
operations12312954_o_per_ations
populations15148714po_pu_lations
promulgations1892834prom_ulgations
purgation1247394___purgation_
recomputations20104104recompu_tations
suppurations1645204suppur_ations

Search took 6 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.360496363.9
2DLD Change Limit95024875.34317784.8
3Display Results87870.0631381.0
 (SQL Overall)178691875.76630990.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.