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

337 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
consols9291407(None) 
consol82614111consol_
console92715981console
consoles103216151consoles
consuls92412311consuls
cansos84915382canso_s
censors93611832censors
cineols9128852cineols
condoes104319202condoes
condole102914952condole
condoles113015802condoles
condoms124214082condoms
condors104018552condors
condos94322332condo_s
congoes103617302congoes
congos94219882congo_s
congous103615082congous
consoled112911442consoled
consoler102812612consoler
consolers112510922consolers
consort91319902consort
consorts101512332consorts
consul82312302consul_
consult92513632consult
consults10219982consults
contos84923232conto_s
controls10311392controls
convoys15267022convoys
cools75632632co__ols
counsels1037572counsels
cresols939642cresols
mongols103310822mongols
podsols1056512podsols
tonsils7310182tonsils
benzols1836673benzols
bolsons969483bolsons
bonbons1139333bonbons
bongoes104314113bongoes
bongos95316653bongo_s
borneols1046343borneols
bosoms104913043bo_soms
bosons85016653bo_sons
canals84421663can_als
cancels114113313cancels
candors104216763candors
canfuls1248423canfuls
cannels93413363cannels
cannoli937263cannoli
cannolis1037863cannolis
cannons94412883cannons
canoes84725883can_oes
canola8313623can_ola
canolas9313993can_olas
canons85522063can_ons
canso75019403canso__
cantals93919573cantals
cantons95221203cantons
cantors94620753cantors
cantos84826973canto_s
canyons124511593canyons
carols85124983c_arols
causals91411183causals
censers94313903censers
censes83721803cens_es
censor84011283censo_r
census84310303cens_us
centals94317053centals
centos85920463cento_s
chansons1337473chansons
chisels12219103chisels
cibols1039523c_ibols
cineol8108203cineol_
cineole91010003cineole
cineoles10109403cineoles
coals76129603co__als
coasts85719133coas_ts
coccous1038993coccous
cocoas104915743co_coas
cocoons11310563cocoons
cocos95624693co_co_s
codons96119463co_dons
coeloms1139063coeloms
coevals1237873coevals
cogons96818113co_gons
cohogs125810273co_hogs
cohos105921853co_ho_s
cohosts12398803cohosts
coils75030083co__ils
collops112611753collops
cologs96517353co_logs
colons86028683co_lons
colors86622373co_lors
cols66553083c___ols
combos125316613combo_s
commons13311043commons
comous10816503co_mous
compels133210883compels
compos124818803compo_s
conatus9310463conatus
conceals123111013conceals
conchas144013313conchas
conches144019813conches
conchos144313953conchos
conchs134714903con_chs
concoct10312903concoct
concocts1138633concocts
concord12510343concord
concords1358593concords
concours1239433concours
concurs11311453concurs
concuss1138063concuss
condo85322593condo__
condoled123110713condoled
condoler113412113condoler
condolers122710563condolers
condom114215363condo_m
condone102616293condone
condones112817393condones
condor94616963condo_r
condores113315633condores
condyle13247053condyle
condyles14277463condyles
cones76457423con__es
coneys115218423con_eys
confabs1435393confabs
confers124120093confers
confess12399903confess
confits122811423confits
conform14310453conform
conforms1538863conforms
congas94417033con_gas
congeals11309853congeals
congees103517923congees
congers104223233congers
conges94928173con_ges
congius103210073congius
congo85623133congo__
congou94313243congo_u
conics103920593con_ics
conies84338593con_ies
conines93827793conines
conins84327233con_ins
conioses10313313conioses
coniosis1048133coniosis
coniums11311863coniums
conjoin1638193conjoin
conjoins1738133conjoins
conkers133721043conkers
conks115525703con__ks
conners94023113conners
connote9311613connote
connotes10311453connotes
conns75024233con__ns
conoid9818883con_oid
conoids10813883conoids
cons66057693con___s
conscious1347583conscious
consent93723113consent
consents102715893consents
consign1038773consign
consigns1137533consigns
consist9316033consist
consists10310593consists
consoling12310873consoling
consomme1445373consomme
consommes1545633consommes
consular1038813consular
consume11510133consume
consumes12310413consumes
contes84432913con_tes
conto76027173conto__
contort91422343contort
contorts101112633contorts
contour939963contour
contours1039613contours
contras93015603contras
control9310673control_
conus76726533con__us
conveys15308223conveys
convoke16207173convoke
convokes17247703convokes
convolve1644653convolve
convolves1745323convolves
convoy14348543convo_y
convulse1345443convulse
coofs105924713co__ofs
cooks115429143co__oks
cool66940493co__ol_
cooly105525423co__oly
coons76737283co__ons
coops96229643co__ops
coos67456493co__o_s
coots75636843co__ots
copals105018943co_pals
copious11311963copious
coplots11511593coplots
copses104922473cops_es
corals85325143co_rals
corbels113813593corbels
cordons104415763cordons
cormels113813373cormels
cormous11312353cormous
corncobs1444723corncobs
cornels94716663cornels
corneous10310033corneous
cornrows1345313cornrows
corrals93713853corrals
corsacs1139013corsacs
corses84433463cors_es
corsets94819803corsets
cortisols1144783cortisols
cosecs105015213co_secs
coses76949493co_s_es
cosets85824403co_sets
coseys115215813co_seys
coshes115022783co_shes
cosies84932153co_sies
cosily113613853co_sily
cosmos10311753co_smos
coss66143493co_s__s
cossets95014283cossets
costly114012333co_stly
costs77231143co_s_ts
cottons9312193cottons
councils1246973councils
counsel948543counsel_
coupons112710553coupons
couscous1246663couscous
cousins9516003cousins
cowboys1735253cowboys
cowls106922213co__wls
coydogs1434493coydogs
coypous14248813coypous
creosols1045713creosols
cresol8310203cresol_
cresyls1234753cresyls
cursors93910023cursors
cussos84210003cusso_s
cymols1377193c_ymols
cytosols1354203cytosols
dobsons1036203dobsons
dongola945473dongola
dongolas1045343dongolas
donjons1536733donjons
donors75115793don_ors
donzels1735393donzels
dorsals84110843dorsals
dorsels84412573dorsels
dossals8379293dossals
dossels85511603dossels
dossils8669773dossils
enols54718403_en_ols
enrols61213383_enrols
ensouls736033_ensouls
foisons1047613foisons
fools86824203fo__ols
formols12299413formols
fossils10379013fossils
godsons966663godsons
gondola946663gondola
gondolas1046193gondolas
gonofs10459863gon_ofs
googols935483googols
gunsels8338133gunsels
hansels104011653hansels
hansoms12238523hansoms
honors94816793hon_ors
hosels94218603ho_sels
housels105312133housels
indols74714203_indols
insole63515863_insole
insoles73516243_insoles
insouls737213_insouls
johnsons1842383johnsons
lintols7339553lintols
losels64714583lo_sels
mondos95217333mondo_s
mongoes103415713mongoes
mongol94912533mongol_
mongos94318623mongo_s
monos75930863mon_o_s
monsoon938493monsoon
monsoons1047343monsoons
mools76027173mo__ols
morsels94112653morsels
noncola948293noncola
noncolas1048613noncolas
noncoms1139183noncoms
nonself1078513nonself
nonsolar847073nonsolar
nonsolid957403nonsolid
nonsolids1045373nonsolids
nonstops10116853nonstops
nonyls957853non_yls
obols73715863_o_bols
onions64016433_onions
onos46229003_on_o_s
onsets64013543_onsets
osmols8137313_osmols
ousels64815273_ousels
pensils92811593pensils
podsol946853podsol_
podzols1934683podzols
poisons9310353poisons
polyols1238493polyols
pontils9312213pontils
pontons93315553pontons
pools74427703po__ols
posole8314223po_sole
posoles9314883po_soles
ransoms92410163ransoms
reconsole1145693reconsole
reconsoles1245143reconsoles
rondels82510053rondels
rondos74616723rondo_s
ronions73313343ronions
ronnels7318613ronnels
ronyons10258433ronyons
santols73513323santols
sensors73514623sensors
snools65715873_snools
sokols10399083so_kols
sols45448163___sols
sotols63714453so_tols
sponsons1045803sponsons
sponsors1045733sponsors
tensors72712373tensors
tinsels738373tinsels
toluols735823toluols
tondos75115913tondo_s
tonsil6311873tonsil_
tools55325243to__ols
topsoils1095143topsoils
torsos64815733torso_s
unsold71410513_unsold
wontons103310533wontons
wools84421463wo__ols

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273376.73319906.0
3Display Results3373370.1103063.6
 (SQL Overall)1786913376.99925530.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.