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

192 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
consort9131990(None) 
consorts101512341consorts
contort91422341contort
censor84011292censor_
censors93611842censors
cohort1110720262co_hort
comfort143611692comfort
comport133616842comport
concert113325222concert
concoct10312902concoct
concord12510342concord
condor94616972condor_
condors104018572condors
conform14310462conform
consent93723112consent
consist9316032consist
consol82614112conso_l
console92715982console
consols92914072consols
consorted1239772consorted
consortia1146252consortia
consult92513632consult
contorts101112642contorts
convert123721472convert
assort64916383_assort
candor94516423candor_
candors104216763candors
cannot83616773canno_t
canso75019403canso__
cansos84915383canso_s
canst74932213cans__t
cantor85621523cantor_
cantors94620753cantors
carport11316033carport
cavort11316173c_avort
censer84516583censer_
censers94313903censers
censored11197953censored
censure92310603censure
coast75236273coas__t
coexert16312363coexert
cohorts123411103co_horts
cohost115217213co_host
coinsure1046933coinsure
colewort13410623colewort
color76123743co_lor_
colors86622373co_lors
comforts15347323comforts
compart134016003compart
comports143411983comports
compost134515353compost
conceit113218073conceit
concent114422513concent
concept133314443concept
concern113011963concern
concerti122912603concerti
concerto123311613concerto
concerts123016063concerts
concocts1138633concocts
concordat1446353concordat
concords1358593concords
concours1239473concours
concur10411103concur_
concurs11311473concurs
condo85322593condo__
condoes104319203condoes
condole102914953condole
condom114215363condo_m
condoms124214083condoms
condone102616293condone
condores113315643condores
condos94322333condo_s
conduct121411593conduct
conduit10713083conduit
confect143614273confect
confer114018683confer_
confers124120093confers
confirm1437363confirm
confit113316403con_fit
conforms1538873conforms
confront13411603confront
conger95024273conger_
congers104223233congers
congest104618773congest
congo85623133congo__
congoes103617303congoes
congos94219883congo_s
congou94313243congo_u
congous103615083congous
conjoin1638203conjoin
conjoint17410373conjoint
conjure16109073conjure
conker124721553conker_
conkers133721043conkers
connect113515743connect
conner84423963conner_
conners94023113conners
connote9311613connote
conodont11411153conodont
conoid9818883con_oid
cons66057693cons___
conscript1547123conscript
consents102715893consents
conserve1339923conserve
consign1038773consign
consists10310593consists
consoled112911453consoled
consoler102812613consoler
consolers112510923consolers
consoles103216153consoles
consomme1445373consomme
consonant11410163consonant
consorting13410743consorting
consortium1454533consortium
conspire1257873conspire
constant10515593constant
constrict13711623constrict
construct1358713construct
construe1049053construe
consul82312303cons_ul
consuls92412313consuls
consults10219983consults
consume11510133consume
contact1144020683contact
content94326153content
contest93523233contest
context163913433context
conto76027173conto__
contorted1239473contorted
contos84923233conto_s
contour939973contour
contours1039653contours
contra83314703con_tra
control9310693control
convect143114483convect
convent123919413convent
converts133213553converts
convict143410983convict
convoke16207173convoke
convoy14348543convo_y
convoys15267023convoys
cookout13410153cookout
coopt95929853co__opt
coot67860383co__o_t
coplot10518273coplo_t
copout10418783co_pout
corpora1139353corpora
corset85636223cors_et
corslet9318063corslet
coset75748843co_s_et
cosset84125863co_sset
cost68057943co_s__t
court75532773co__urt
covert114925503co_vert
cursor84110293cursor_
cursors93910023cursors
cursory12406393cursory
donnert82815533donnert
donor64418193don_or_
donors75115793don_ors
fanwort13310733fanwort
gosport101010283gosport
honewort14410083honewort
honor85718623hon_or_
honors94816793hon_ors
hornwort1447793hornwort
insert64325253_insert
intort6418923_intort
missort9314653missort
monsoon938493monsoon
moonport1257193moonport
moonwort1367813moonwort
nonart6319193non_art
noncore9411953noncore
nonstory1148103nonstory
nonsuit7811343nonsuit
nonword1149153nonword
nonwork1448423nonwork
onset54730173_ons_et
onshore10310013_onshore
presort95219543presort
resort65728623_resort
sensor63813843sensor_
sensors73514643sensors
sensory10329093sensory
snort54833753_sn_ort
sort46264813___sort
sponsor934973sponsor_
sponsors1045753sponsors
tensor63812673tensor_
tensors72712373tensors
tonsure758783tonsure

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271925.95322514.2
3Display Results1921920.0633047.6
 (SQL Overall)1786911926.42227824.8
 
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.