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

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

64 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
contest9352323(None) 
congest104618771congest
content94326151content
contes84432911contes_
contests103413381contests
context163913431context
boniest93318992boniest
coattest1038862coattest
coldest102514762coldest
comtes106222812comtes_
conceit113218072conceit
concent114422512concent
concept133314442concept
concert113325222concert
cones76457422con_es_
confect143614272confect
confess12399902confess
conges94928172conges_
congests113510382congests
conies84338592conies_
connect113515742connect
conquest1939552conquest
consent93723112consent
consist9316032consist
contact1144020682contact
conte76633202conte__
contemn1137802contemn
contempt1447472contempt
contend103511892contend
contents104018212contents
contessa1044582contessa
contested12310692contested
contester11311182contester
contexts17378652contexts
contort91422342contort
contos84923232contos_
contrast102614782contrast
contuse9311412contuse
convect143114482convect
convent123919412convent
convert123721472convert
coolest9318642coolest
corniest102117302corniest
cosiest93819852cosiest
cotes76347842co_tes_
countess103710052countess
couthest13312082couthest
cowiest123614672cowiest
coyest11316052co_yest
coziest184014352coziest
curtest9713962curtest
cutest85820142c_utest
fondest11312402fondest
honest94822422hon_est
hottest10411382hottest
longest84114952longest
montes84226932montes_
mostest9314792mostest
obtest81213012_obtest
oftest91212002_oftest
pontes83627852pontes_
scantest101710182scantest
softest10310602softest
toniest73218902toniest

Search took 4 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 Filter1786911076710.1401276364.3
2DLD Change Limit107671642.95336461.6
3Display Results64640.0302133.3
 (SQL Overall)178691643.12357217.7
 
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.