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

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

110 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
counterexamples28251531counterexamples_
counterexample27151722counterexample__
counterplea1547035counter____ple_a
counterpleas1655805counter____pleas
counterargues1685046counter__argues_
countercampaign2471676counter_campaign
counterchanges22124226countercha_nges_
countercharges22104116countercha_rges_
counterimages1854616counter__images_
countermarches2373746counter_marches_
countermeasures19122296countermeasures_
countermines1649156counter___mines_
countermoves1956016counter___moves_
counterpanes1649306counter_pa__nes_
counterrallies1683956counter_rallies_
counterspies1648316counter___spies_
counterstates1586646countersta__tes_
counterstyles1854786counter__styles_
countertrades1655896countertra__des_
countervailed19154896counter_va_ile_d
countervails1755996counter_va_il_s_
chanterelles1751907chantere___lles_
contextless2052487co_nt__ex__tless
contredanses1552887co_nt_reda_nses_
contretemps1751777co_nt_retemp__s_
countenances1655737count__ena_nces_
counteracted1747367counter__a_cte_d
counteracts1547517counter__a__cts_
counteragent1557697counter__a__gent
counteragents1655177counter__agents_
counterargue1555307counter__argue__
counterargued1754227counter__argue_d
counterassaults1791447counterassaults_
counterbalances21122827counterbalances_
counterblast1655407counter____blast
counterblasts1754007counterbla__sts_
counterchange2194867countercha_nge__
counterchanged23103777countercha_nge_d
countercharge2194297countercha_rge__
countercharged23113617countercha_rge_d
counterclaimed2163527countercla_ime_d
counterclaims1954447countercla__ims_
countercoups1854607counter_coup__s_
countercries1648997counter___cries_
countercultures1962237countercultures_
counterdemands2062397counter_demands_
counterefforts2282057countere_fforts_
counterfires1747067counter___fires_
counterfoils1755397counter__foil_s_
counterforces2085557counter__forces_
counterguerilla1871417countergueril_la
counterimage1754987counter__image__
countermanded1974687counter_ma_nde_d
countermands1746237counter___mands_
countermarched2483187counter_marche_d
countermeasure18122637countermeasure__
countermelodies2092167countermelodies_
countermelody2162657counter___melody
countermemo1754727counter___m__emo
countermemos1854437counter___memos_
countermen1449297counter___m__e_n
countermine1549747counter___mine__
countermove1855857counter___move__
countermoved2054997counter___move_d
countermyths2253557counter___myths_
counterpane1549317counter_pa__ne__
counterparts1646717counter_pa__rts_
counterplan1586777counter____pl_an
counterplans1687147counter____plans
counterplay18105607counter____pl_ay
counterplayer2055047counterpla__ye_r
counterplayers2153807counterpla__yers
counterplays1995607counter____plays
counterplot1596817counter____pl_ot
counterplots16106237counter____plots
counterploy18105207counter____pl_oy
counterploys1995357counter____ploys
counterpoise1657357counter____poise
counterpoises1756417counter__poises_
counterpose1547507counter____p_ose
counterposed1756327counter____posed
counterposes1647627counter____poses
counterproposal21101337counter_prop_osal
counterprotest1864437counter__protest
counterpunches2383247counter_punches_
counterraids1556607counter_ra__ids_
counterrallied1763257counter_ra_llied
counterrally1755527counter_ra__l_ly
counterresponse1961767counter_response
countershadings2272707countershadings_
countersniper17104557counter_snip_e_r
countersnipers1893277counter_snip_ers
counterspell1653917counter___sp_ell
counterspells1753467counter___spells
counterstained1754847countersta_ine_d
counterstains15156627countersta__ins_
counterstate1457037countersta__te__
counterstated1665637countersta__te_d
countersteps1655887counter_step__s_
counterstrikes2094747counter_strikes_
counterstrokes2064627counter_strokes_
counterstyle1755057counter__style__
countersues1348537counter____sues_
countertactics1763367counter_tactics_
countertops1546357counter__top__s_
countertrade1556297countertra__de__
countervail1655657counter_va_il___
countervailing2063737counter_va_iling
counterworlds1953467counter__worlds_
unexampled2241697__un___example_d

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 Filter178691950240.360496363.9
2DLD Change Limit950241108.57611080.2
3Display Results1101100.0761447.4
 (SQL Overall)1786911109.01219828.1
 
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.