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

187 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
counterplotting2062801counterplotting_
counterplotted1963414counterplott__ed
counterpointing2063034counterpointing_
counterpoising19164194counterp_oising_
counterposing1885444counterp_o_sing_
contemplating2054125co_ntempl_ating_
counteracting1856285counter__acting_
counterclaiming2262925counterclaiming_
counterfeiting2054025counter_feiting_
countermoving2154165counter_mo_ving_
counterplot1596815counterplo_t____
counterplots16106235counterplo_t___s
counterpoint1658175counterp_o__in_t
counterpoints1755625counterp_o__ints
counterpunching2562365counterpunching_
counterstating1755195counter_stating_
outplotting1443755_ou_t__plotting_
overplotting1845045_o__verplotting_
complotting18124256co____mplotting_
coplotting1555956co_____plotting_
counterarguing18113406counter_arguing_
counterchanging24162976counterchanging_
countercharging24183066countercharging_
counterchecking2662556counterchecking_
countering13314476counter_____ing_
countermanding2053746counter_manding_
countermarching2562606countermarching_
counterordering19162416counterordering_
counterpetition1961946counterp_etition
counterplan1586776counterpl___an__
counterplans1687146counterpl___an_s
counterplea1547036counterpl_____ea
counterploy18105206counterplo_____y
counterploys1995356counterplo____ys
counterpointed1953596counterp_o__inted
counterpoise1657356counterp_o__i_se
counterpoised1855306counterp_o__ised
counterpoises1756416counterp_o__ises
counterprotest1864436counterpro_t_est
counterprotests1962426counterpro_tests
counterrallying2162276counterrallying_
countershading2163836counter_shading_
countershadings2272706counter_shadings
countersigning1863226counter_signing_
countersinking2163486counter_sinking_
counterstain14156786counter__stain__
counterstained1754846counter__stained
counterstaining1863246counterstaining_
counterstains15156626counter__stain_s
counterstriking2262946counterstriking_
countersuing1547086counter___suing_
countervailing2063736counter_vailing_
interknotting1852666__interknotting_
interplanting1655346__interplanting_
interpolating1657796__interpolating_
outtrotting1244106_ou_ttr__otting_
underclothing2061896__underclothing_
underclothings216966__underclothings
underletting1454186__under_letting_
anticlotting15113007__ant_iclotting_
chuntering1647807chunter_____ing_
coemploying2152417co___emplo_ying_
cointerring1447147cointer____ring_
concertgoing1852627co_ncertgo__ing_
concertgoings1961677co_ncertgo__ings
concertina14410607co_ncer____tin_a
concerting15313897co_ncer____ting_
confronting1744867co_n_fr__onting_
constellating1653267conste__llating_
consternating1654977conster__nating_
contemplation1985267co_ntempl_ati_on
contemplations2074727co_ntempl_ations
contemplative22123707co_ntempl_ati_ve
contemplatives23122777co_ntempl_atives
contemporizing3092807co_ntemporizing_
contenting13313327co_nte____nting_
contesting13312217co_nte____sting_
contorting13410107co_nt____orting_
contracting16610477co_nt_r__acting_
contradicting1954077co_nt_radicting_
contrasting1459357co_nt_r__asting_
contributing1754307co_nt_r_ibuting_
controlling1445427co_nt_r__olling_
controverting1953367co_nt_roverting_
converting16313137co_nver____ting_
counseling1345467counse__l___ing_
counselings1442717counse__l___ings
counselling1444407counse__l__ling_
counsellings1552117counse__l__lings
countenancing1853137counte__nancing_
counteraction1755387counter__acti_on
counteractions1855027counter__actions
counteractive2055957counter__acti_ve
counterattack2172737counter__att_ack
counterattacks2272257counter__attacks
counterblast1655407counterblast____
counterblasts1754007counterblast___s
counterblockade2671017counterblo_ckade
counterblow1853907counterblo_____w
counterblows1954217counterblo____ws
countercampaign2471677countercampai_gn
counterchange2194867counter___change
counterclaim1854757countercl__ai__m
counterclaimed2163527countercl__aimed
counterclaims1954447countercl__ai_ms
counterflow1954007counterflo_____w
counterflows2054357counterflo____ws
counterfoil1655207counter_fo__i__l
counterfoils1755397counter_fo__i_ls
counterguerilla1871407counter_guerilla
counterinstance19101797counter_instance
counterion1249537counter_io___n__
counterions1349827counter_io___n_s
counterirritant1771737counterirritan_t
countermelodies2092167countermelo_di_es
countermine1549747counter____min_e
countermines1649157counter____mines
counterpane1549317counterp____an_e
counterpanes1649307counterp____anes
counterpart1547807counterp_art____
counterparts1646717counterp_art___s
counterplay18105607counterpl_____ay
counterplayer2055047counterpl___ayer
counterplayers2153807counterpl__ayers
counterplays1995607counterpl____ays
counterpleas1655807counterpl____eas
counterpose1547507counterp_o____se
counterposed1756327counterp_o___sed
counterposes1647627counterp_o___ses
counterpower1965867counterp_o___wer
counterpowers2064827counterp_o__wers
counterproject2763197counterpro__ject
counterprojects2862157counterpro_jects
counterproposal21101337counterpro_posal
counterpunch2154197counterp____unch
counterquestion2671217counterquesti_on
counterreaction19102377counterreacti_on
countershot1656637countersho_t____
countershots1755937countersho_t___s
countersign1447247counter____si_gn
countersigns1546427counter____signs
countersink1748067counter____sin_k
countersinks1846167counter____sinks
counterstrategy2182137counterstrat_egy
counterstrike1965297counter__stri_ke
counterstrikes2094747counter__strikes
countertactic1663917counter_tacti__c
countertactics1763367counter_tacti_cs
countertenor1454757counter____tenor
countertrend1575947counter___tren_d
countertrends1674357counter___trends
counterviolence2271567countervio_lence
dogtrotting1462037do_gt_r__otting_
foxtrotting2251737fo_xt_r__otting_
intercutting1545947__inter_cutting_
interflowing1953667__interflo_wing_
interknitting1853287__interknitting_
interlocking1954907__inter_locking_
interlooping1554317__inter_looping_
interloping1446967__inter_lo_ping_
intermatting1547177__inter_matting_
intermitting1547257__inter_mitting_
interpellating1754537__interpellating_
interplaying1845517__interpl_aying_
interpleading1754207__interpleading_
interposing1447807__interp_o_sing_
interpreting1588307__interp_reting_
nondepleting1652847no_nde_pl_eting_
nonterminating1773127no_nterminating_
outfloating1544367_ou_t__floating_
outplodding1642697_ou_t__plodding_
outputting1345087_ou_t__p_utting_
outrooting1147937_ou_t_r__ooting_
overexploiting2762857_overexploiting_
overletting1548017_o__ver_letting_
overplanting1846967_o__verplanting_
reinterpreting1762327reinterp_reting_
replotting1357047____re_plotting_
undercoating1645377__under_coating_
undercoatings1753067__under_coatings
undercutting1653767__under_cutting_
underloading1564297__under_loading_
underpainting1763557__underpainting_
underpaintings1862027__underpaintings
underplaying19154357__underpl_aying_
underpropping1852287__underpropping_
undershooting1852557__undershooting_

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.1261418182.5
2DLD Change Limit950241878.78010822.8
3Display Results1871870.1401335.7
 (SQL Overall)1786911879.04619753.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.