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

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

121 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
combaters153811(None) 
combater1439381combater_
bombasters1643712bombasters
coaters93525792co__aters
comakers16339172com_akers
comates114123642com_ate_s
combated1539822combate_d
combats13311682combat__s
combers134516622comb__ers
combiners15247942combiners
commuters15378912commuters
compacters18247032compacters
comparers15319392comparers
computers15339752computers
cymbalers1842842cymbalers
abaters95115203__abaters
boaters93419243bo__aters
bombarders17153203bombarders
bombaster1543803bombaster_
bombers134512593bomb__ers
cambers134017443camb__ers
caters85336503c___aters
cementers1338313cementers
cheaters133613513c_heaters
coalers94419353co__alers
coasters104317343co_asters
coatees93816553co__atees
coater84329573co__ater_
coaxers164311083co__axers
cobbers134114753co_b_bers
cobblers14359593co_bblers
cognates11311583cognate_s
cohabiters1743403cohabiters
cohobates1646523cohobate_s
cointers103616423co_inters
coleaders1237823coleaders
collates103019143collate_s
collators11410343collators
colters93522443co__lters
comaker153410603com_aker_
comakes154413643com_ake_s
comanagers1543833comanagers
comate104124843com_ate__
comatiks16148043com_atiks
combat12316753combat___
combatant1546053combatant
combatants1653443combatants
combating16310163combating
combative1847213combative
combatted1644653combatted
comber125118503comb__er_
combes125321733comb__e_s
combineds16255283combineds
combiner14259723combiner_
combines142814623combine_s
combustors1643753combustors
comembers1744223comembers
comers105328083com___ers
comethers1637443comethers
comforters17275203comforters
commanders17146683commanders
commenters16139483commenters
commoners15339783commoners
communers15338413communers
commuter143010153commuter_
commutes143011893commute_s
compacter17257883compacter_
compactors18256253compactors
compadres16266413compadres
comparer143611363comparer_
compares143816433compare_s
compeers143410013com_peers
competes144117243compete_s
compilers1537053compilers
completers16298323completers
compliers1538293compliers
composers153910643composers
composters16388333composters
compotes144716513compote_s
computer144511513computer_
computes143914553compute_s
comradery1793493comradery
comrades13149773comrade_s
comtes106222813com__te_s
confuters1437793confuters
cooters94525733co__oters
copters113621283co__pters
costers94128343co__sters
cottagers12305383cottagers
cotters94323453co__tters
coulters103614313co_ulters
counters103320193co_unters
courters103015373co_urters
couters93827303co__uters
coveters132411083co_veters
cowbanes1537423cowbane_s
cowriters14317293cowriters
crabeaters1444503crabeaters
craters95021893c__raters
cumberers15176003cumberers
cumbers134515413cumb__ers
cutwaters1443613cutwaters
cymbaleers1951413cymbaleers
cymbaler1743113cymbaler_
debaters113511923_debaters
doubters11257393doub_ters
fomenters1437853fomenters
homagers1486833hom_agers
lobsters10268743lo_bsters
locaters102710073lo_caters
maters85032393__m_aters
mobsters12359063mo_bsters
oaters65029793_o__aters
ombers104214403_omb__ers
omitters10277653_omitters
orbiters1036603_orbiters
rebaters103413943_rebaters
sorbates10311103sorbate_s
vomiters1337203vom_iters
wombats1435893wombat__s
zoolaters1844983zoolaters

Search took 8 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 Filter1786911486410.436409841.7
2DLD Change Limit1486411216.79621871.8
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.27824552.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.