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

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

55 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
counterinstance19101791counterinstance_
countenance1555875counte__n__ance_
countenanced1754205counte__n__anced
countenancer1654225counte__n__ancer
countenances1655735counte__n__ances
counterbalance20123245counter_balance_
counterbalanced22142575counter_balanced
counterbalances21122825counter_balances
counterstained1754845counter__stained
counterstate1457035counter__sta_te_
counterstated1665635counter__sta_ted
counterstates1586645counter__sta_tes
continuance1555126co_nt__in_uance_
continuances1654686co_nt__in_uances
contrivance1854266co_nt_ri__vance_
contrivances1954136co_nt_ri__vances
conversance1876326co_nver__s_ance_
conversances1975726co_nver__s_ances
countenancers1752986counte__n__ancers
counterattack2172736counter_atta_c_k
counterattacked2471956counter_attacked
counterattacker2371796counter_attacker
counterattacks2272256counter_atta_cks
counterchange2194866counter__change_
counterchanged23103776counter__changed
counterchanges22124226counter__changes
counterevidence2391586counterevidence_
counterimage1754986counteri__ma_ge_
counterimages1854616counteri__ma_ges
counterirritant1771736counterirritan__t
countermanded1974686counter___manded
counterpane1549316counter___pan_e_
counterpanes1649306counter___pan_es
counterresponse1961766counterresponse_
countersigned1784356counter__sign_ed
counterstain14156786counter__sta__in
counterstaining1863246counter__staining
counterstains15156626counter__sta_ins
counterstating1755196counter__stating
counterstep1547116counter__st___ep
counterstream1773736counter__st__ream
counterstricken2372746counter__stricken
counterstrike1965296counter__strike_
counterstrikes2094746counter__strikes
counterstroke1954786counter__stroke_
counterstrokes2064636counter__strokes
counterstruck2163196counter__struc_k
counterstyle1755056counter__st_yle_
counterstyles1854786counter__st_yles
counterviolence2271566counterviolence_
nonresistance1562656no_nresi_stance_
nonresistances1662196no_nresi_stances
outdistance1452016_ou_t_di_stance_
outdistanced1651266_ou_t_di_stanced
outdistances1551766_ou_t_di_stances

Search took 7 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.360496363.9
2DLD Change Limit65874555.96611041.6
3Display Results55550.0331666.7
 (SQL Overall)178691556.35928100.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.