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

101 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
contoured123730(None) 
coloured1148312co_loured
conjured18117902con_jured
contorted1239482contorted
contour939972contour__
contours1039652contour_s
contused1138442cont_used
honoured1236312hon_oured
recontoured1453232recontoured
cantered113415993cant_ered
cantoned111411523canto_ned
captured1336573capt_ured
censored11197953censo_red
censured11248913cen_sured
centaurea1143503centaurea
centered112513523cent_ered
centred103411683cent__red
cinctured1444273cinctured
clamoured1444083clamoured
clangoured1441633clangoured
clotured11246163clot_ured
cloured103111543c__loured
coendured1344093coendured
coiffured1842613coiffured
coinsured1245513coinsured
cointerred1346563cointerred
colored10313473co_lo_red
colourer1037563co_lourer
concluded1544033concluded
concocted1346773concocted
concord12510343conco_r_d
concours1239473concour_s
concourse1345803concourse
concourses1445353concourses
concurred1445673concurred
condoled123110723condo_led
condoned122612023condo_ned
condores113315643condo_res
conduced14136963con_duced
conferred1537753conferred
configured1743323configured
conformed1767463conformed
confound1445903confou_nd
confounded1743293confounded
confused1437033con_fused
confuted1437683con_futed
conjoined1965463conjoined
conjure16109073con_jure_
conjurer17117683con_jurer
conjures17119913con_jures
connoted1138863conno_ted
conquered2145463conquered
consoled112911453conso_led
consorted1239773consorted
conspired1445663conspired
construed1247313constru_ed
consumed1337923con_sumed
contacted14139103contacted
contained12310893contained
contemned1446793contemned
contended1339273contended
contented12313043contented
contested12310703contested
continued1248483continued
contort91422343conto_r_t
contorts101112643conto_rts
contouring1347013contouring
contrived1547993contrived
controlled1345383controlled
contuse9311413cont_use_
contuses10413453cont_uses
convoked18236163convo_ked
convoluted1643703convoluted
convolved1844083convolved
convoyed17225553convo_yed
costarred1244703costarred
costumed1365033cost_umed
cottered112511743co_ttered
cottoned1138033cotto_ned
countered12313003count_ered
couture9310623cout_ure_
coutures10311993cout_ures
cultured1137233cult_ured
detoured1036513_detoured
doctored1245623docto_red
honored11310123hon_o_red
honourer1146243hon_ourer
inpoured1135813_inpoured
jointured17133483joint_ured
mentored1138003mento_red
monitored1245583monito_red
motored1039933mo_to_red
nontenured1143133nontenured
outpoured1246013_outpoured
postured1139493post_ured
rancoured1244703rancoured
tonsured976383ton_sured
tortured935843tort_ured
toured74216153___toured
unsoured9310063_unsoured
ventured1238273vent_ured

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411017.87318879.8
3Display Results1011010.0333060.6
 (SQL Overall)1786911018.35921377.1
 
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.