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

187 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
contorts10111264(None) 
consorts101512341consorts
contort91422341contort_
cantors94620752cantor_s
cohorts123411102co_horts
comforts15347322comforts
comports143411982comports
concerts123016062concerts
concocts1138632concocts
concords1358592concords
condores113315642condores
condors104018572condor_s
conforms1538872conforms
consort91319902consort_
contacts123215212contacts
contents104018212contents
contests103413382contests
contexts17378652contexts
contorted1239472contorted
contos84923232conto__s
contours1039652contours
contras93015622cont_ras
controls10311392controls
converts133213552converts
intorts7310972_intorts
bistorts10118813bistorts
candors104216763candor_s
canters94827733canter_s
cantons95221203canto_ns
cantor85621523cantor__
cantos84826973canto__s
captors113914983captor_s
carports1238943carports
castors94919443castor_s
cavorts1237933c_avorts
censors93611833censor_s
centares102913893centares
centers94420603center_s
centones10313663centones
centos85920463cento__s
centres93817123cent_res
chantors133710263chantor_s
clitoris1047873clitoris
coactors1239473coactor_s
coaters93525793coater_s
coexerts1734883coexerts
cohort1110720263co_hort_
cohosts12398813co_hosts
cointers103616413cointer_s
coleworts1445863coleworts
colors86622373co_lor_s
colters93522443colter_s
comfort143611693comfort_
comparts144210833comparts
comport133616843comport_
composts144210913composts
conceits122813613conceits
concents122516603concents
concepts143110303concepts
concerns122710833concerns
concert113325223concert_
concerti122912603concerti
concerto123311613concerto
concertos132711133concertos
concoct10312903concoct_
concord12510343concor_d
concordats1544193concordats
concours1239473concours
concurs11311473concur_s
condoes104319203condo_es
condoles113015803condoles
condoms124214083condo_ms
condones112817393condones
condor94616973condor__
condos94322333condo__s
conducts13118713conducts
conduits111210063conduits
confects153110873confects
confers124120093confer_s
confirms1536303confirms
confits122811423con_fits
conform14310453confor_m
confronts1447063confronts
congers104223233conger_s
congests113510383congests
congoes103617303congo_es
congos94219883congo__s
congous103615083congo_us
congrats11311433congrats
conioses10313313conioses
coniosis1048133coniosis
conjoins1738133conjoins
conjures17119913conjures
conkers133721043conker_s
connects123010563connects
conners94023113conner_s
connote9311613conno_te
connotes10311453connotes
conodonts1246063conodonts
conoids10813883con_oids
consents102715893consents
consists10310593consists
consoles103216153consoles
consols92914073conso_ls
consorted1239773consorted
consortia1146253consortia
constants11410913constants
consults10219983consults
contact1144020683contact_
contains10316533contains
contemns1237403contemns
contempts1545063contempts
contends112810573contends
content94326153content_
contes84432913cont__es
contest93523233contest_
context163913433context_
conto76027173conto___
contorting13410103contorting
contortion1248663contortion
contortions1348683contortions
contortive1546843contortive
contour939973conto_ur
contoured1237303contoured
contra83314703cont_r_a
contracts132212013contracts
contrast102614783cont_rast
contrasts112211043contrasts
contrite10318543contrite
control9310693cont_rol
controverts1654263controverts
contuses10413453contuses
convects153410993convects
convents132614603convents
convert123721473convert_
convicts15337713convicts
convokes17247703convokes
convoys15267023convo_ys
cookouts1446003cookouts
coopts105814583co__opts
cooters94525723cooter_s
coots75636843co__o_ts
coplots11511593coplo_ts
copouts11311083co_pouts
copters113621283copter_s
costards113510793costards
costars94218013costar_s
costers94128333coster_s
cottars94412243cottar_s
cotters94323443cotter_s
cottons9312193cotto_ns
counters103320193counter_s
courts84216173co__urts
couters93827303couter_s
coutures10311993coutures
coverts124813813co_verts
cutouts938033c_utouts
distorts91112353distorts
doctors1039993doctor_s
dogtrots1044693dogtrots
donators9310403donator_s
donors75115793don_or_s
extorts1447753_extorts
fanworts1446103fanworts
foetors1039763foetor_s
foxtrots1843923foxtrots
gosports1185913gosports
honeworts1545813honeworts
honors94816793hon_or_s
hornworts1544393hornworts
intort6418923_intort_
mentors9314993mentor_s
monitors10310823monitor_s
monteros1039453monteros
moonports1344403moonports
moonworts1444743moonworts
motors84616603mo_tor_s
nonarts7311303non_arts
nonwords1247463nonwords
outports1048273_outports
pontons93315553ponto_ns
pontoons10279313pontoons
retorts76016513_retorts
rotors64917953ro_tor_s
snorts64116503_sn_orts
torts56138123___torts
wontons103310533wonto_ns

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621877.36019859.0
3Display Results1871870.0762460.5
 (SQL Overall)1786911877.59223536.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.