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

57 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
counterbalances21122821counterbalances_
counterbalance20123242counterbalance__
counterbalanced22142572counterbalance_d
countenances1655735counte___nances_
counterblast1655405counterb_la___st
counterblasts1754005counterb_la_sts_
counterchanges22124225counter_changes_
counterpanes1649305counter__pan_es_
counterplans1687145counter_plan__s_
counterrallies1683955counterral_lies_
outbalances1552725_ou_t__balances_
overbalances1953155_o__verbalances_
contrivances1954136co_nt_r_ivances_
conversances1975726co_nver__sances_
convertaplanes21111766co_nvertaplan_es_
countenance1555876counte___nance__
countenanced1754206counte___nance_d
countenancer1654226counte___nance_r
countenancers1752986counte___nancers
counteracts1547516counter___a_cts_
counteragents1655176counter_agen_ts_
counterargues1685046counter_a_rgues_
counterattacks2272256counter_attacks_
counterblows1954216counterb_l__ows_
counterchange2194866counter_change__
counterchanged23103776counter_change_d
countercharges22104116counter_charges_
counterclaimed2163526counter_claime_d
counterclaims1954446counter_cla_ims_
countercultures1962236countercultures_
counterdemands2062396counterdeman_ds_
counterforces2085556counter__forces_
counterimages1854616counter_ima_ges_
counterinstance19101796counterinstance__
countermanded1974686counter__mande_d
countermands1746236counter__man_ds_
countermarches2373746counterma_rches_
countermelodies2092166countermelodies_
countermines1649156counter__min_es_
counterpane1549316counter__pan_e__
counterplan1586776counter_plan____
counterplayer2055046counter_pla_ye_r
counterplayers2153806counter_pla_yers
counterplays1995606counter_pla__ys_
counterplea1547036counter_pl___e_a
counterpleas1655806counter_pl___eas
counterpunches2383246counter__punches_
counterrallied1763256counterral_lie_d
counterstates1586646counter_sta_tes_
countertactics1763366countertactic_s_
countertrades1655896counter_tra_des_
counterviolence2271566counterviolence__
outbalance1452946_ou_t__balance__
outbalanced1652076_ou_t__balance_d
overbalance1853356_o__verbalance__
overbalanced2052696_o__verbalance_d
unbalances1443516__un___balances_

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 Filter178691658740.326548131.9
2DLD Change Limit65874575.36012289.9
3Display Results57570.0461239.1
 (SQL Overall)178691575.73231174.3
 
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.