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

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

81 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
advertisers155254(None) 
advertiser1443611advertiser_
advertises1445911advertise_s
advertise1346102advertise__
advertised1544092advertise_d
advertizes2344672advertize_s
adventives1745123adventive_s
adventurers1552433adventurers
advertising16143613advertising
advertisings17131783advertisings
advertize2245383advertize__
advertized2443793advertize_d
advisers12135003adv___isers
appetisers1442933appe_tisers
averters11249513a_vert__ers
addressers1242674ad_dressers
adenitises1145724adenitise_s
adherers1296924adher___ers
adjectives2343734adjective_s
advections1645554advecti_ons
advective1845234advective__
adventitias1552274adventitias
adventive1645814adventive__
adventurer1442974adventurer_
adventures1444764adventure_s
adventuress1552894adventuress
adverbials1652084adverbi_als
adversary1642484adver__sary
adversatives1952474adversative_s
adverse1145954adver__se__
adversely1642844adver__sely
adverseness1553604adverseness
adversities1564354adversities
adverted1336104advert__e_d
advertences1754054advertences
advertent1356594advert__ent
adverting1437224adverti__ng
advertisement19163194advertisement
advertisements20182854advertisements
advertizing25144304advertizing
adverts11308514advert____s
advisees12154134adv___isees
adviser11135784adv___iser_
advises11138974adv___ise_s
advisors12143904adv___isors
aftertimes1544734aftertime_s
albertites1244874albertite_s
amortises1178824a_mortise_s
appetiser1344444appe_tiser_
appetizers2343024appe_tizers
appraisers1443504a_ppraisers
apprisers1345054a_ppr_isers
aspersers11377244asper__sers
asserters956394assert__ers
aversives1545914a_versive_s
averter102410554a_vert__er_
deriders102411854_d_er_iders
derivers123811364_d_er_ivers
dermises112512024_d_ermise_s
derrises93012784_d_errise_s
despisers1245154_d_espisers
devisers12339864_d_e_visers
diverters13227874divert__ers
exercisers1942854_exercisers
expertises1947104expertise_s
invertases1345784invertase_s
inverters12239754invert__ers
mortisers1186164__mortisers
overtimes141511304_overtime_s
overtires121412374_overtire_s
poetisers1145304_poe_tisers
poverties1439514poverti_e_s
reversers12298484rever__sers
reverters122710434revert__ers
unadvertised1751554unadvertise_d
uveitises1243644_uveitise_s
verditers1344994__verditers
verniers11227844__verni_ers
versers103813524__ver__sers
vertices13612284__vertice_s
vetivers1435164__ve_tivers

Search took 9 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 Filter1786911488190.440406115.9
2DLD Change Limit148819818.10618359.1
3Display Results81810.0332454.5
 (SQL Overall)178691818.57920828.9
 
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.