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

105 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
contorted123948(None) 
consorted1239771consorted
comforted17315962comforted
comported16319532comported
concerted14312112concerted
concocted1346772concocted
conformed1767462conformed
connoted1138862conno_ted
contacted14139102contacted
contented12313042contented
contested12310702contested
contort91422342contort__
contorts101112642contort_s
contoured1237302contoured
converted15311562converted
intorted9310122_intorted
cantered113415993canter_ed
cantoned111411523canto_ned
cavorted1435693c_avorted
censored11197953censor_ed
centered112513523center_ed
centred103411683cent_r_ed
coexerted1944763coexerted
cohosted1436143co_hosted
cointerred1346563cointerred
colored10313473co_lor_ed
comforter16255983comforter
comparted16338423comparted
composted16378823composted
conceited14310423conceited
concerned1438643concerned
concocter1247633concocter
concord12510343concor__d
concreted1439413concreted
concurred1445673concurred
condoled123110723condo_led
condoned122612023condo_ned
condores113315643condor_es
conducted1547313conducted
confected1739073confected
conferred1537753conferred
confirmed1745563confirmed
conflated1539333conflated
conformer1667463conformer
confronted1644193confronted
confuted1437683con_futed
congested1338673congested
conjoined1965463conjoined
conjured18117903conjur_ed
connected1438753connected
connote9311613conno_te_
connotes10311453conno_tes
consented12311943consented
conserved1538853conserved
consisted1238513consisted
consoled112911453conso_led
consort91319903consort__
consortia1146253consortia
consorts101512343consort_s
construed1247313construed
consulted1277923consulted
contactee13149313contactee
contained12310893contained
contemned1446793contemned
contended1339273contended
contester11311193contester
continued1248483continued
contorting13410103contorting
contortion1248663contortion
contortive1546843contortive
contracted1549823contracted
contrasted1348583contrasted
contrite10318543contrite_
contrived1547993contrived
controlled1345383controlled
controverted1852913controverted
contused1138443cont_used
convected1738783convected
convented15410753convented
converged1636973converged
conversed1538683conversed
converter14311013converter
convicted1746323convicted
convoked18236163convo_ked
convoluted1643703convoluted
convolved1844083convolved
convoyed17225553convo_yed
coopted123710773co__opted
coplotted1444793coplotted
corotated122810053corotated
costarred1244703costarred
cottered112511743cotter_ed
cottoned1138033cotto_ned
countered12313003counter_ed
courted103514923co__urted
distorted1139373distorted
doctored1245623doctor_ed
extorted1636233_extorted
honored11310123hon_or_ed
mentored1138003mentor_ed
monitored1245583monitor_ed
motored1039933mo_tor_ed
retorted9312333_retorted
snorted83813493_sn_orted
unsorted9312513_unsorted

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.453394461.4
2DLD Change Limit1486411057.06321045.0
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.56223630.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.