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

231 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
convoys1526702(None) 
conveys15308221conveys
convoy14348541convoy_
condoes104319202condoes
condoms124214082condoms
condors104018572condors
condos94322332condo_s
coneys115218422con_eys
congoes103617302congoes
congos94219882congo_s
congous103615082congous
consols92914072consols
contos84923232conto_s
convey144610222convey_
convoke16207172convoke
convokes17247702convokes
convoyed17225552convoyed
coveys145413502co_veys
cowboys1735252cowboys
envoys1255142_envoys
annoys967523_annoys
bonbons1139333bonbons
bongoes104314113bongoes
bongos95316653bongo_s
candors104216763candors
cannons94412883cannons
canoes84725883can_oes
canons85522063can_ons
cansos84915383canso_s
cantons95221203cantons
cantors94620753cantors
cantos84826973canto_s
canvas113813333canv_as
canvass12376873canvass
canyons124511593canyons
carboys144711783carboys
censors93611843censors
centos85920463cento_s
cineols9128853cineols
cloys104916943c__loys
coccous1039003coccous
cocoas104915743co_coas
cocoons11310563cocoons
cocos95624693co_co_s
codons96119463co_dons
coeloms1139063coeloms
coevals1237873coevals
cogons96818113co_gons
cogways1634633cogways
cohogs125810273co_hogs
cohos105921853co_ho_s
colbys13407153co_lbys
collops112611753collops
cologs96517353co_logs
colons86028683co_lons
colors86622373co_lors
combos125316613combo_s
commons13311043commons
comous10816503co_mous
compos124818803compo_s
conatus9310463conatus
conchas144013313conchas
conches144019813conches
conchos144313963conchos
conchs134714903con_chs
conchy163710223conchy_
concoct10312903concoct
concocts1138633concocts
concord12510343concord
concords1358593concords
concours1239473concours
concurs11311473concurs
concuss1138063concuss
condo85322593condo__
condole102914953condole
condoles113015803condoles
condom114215363condo_m
condone102616293condone
condones112817393condones
condor94616973condo_r
condores113315643condores
cones76457423con__es
coney105932883con_ey_
confabs1435393confabs
confers124120093confers
confess12399903confess
confits122811423confits
conform14310463conform
conforms1538873conforms
congas94417033con_gas
congees103517923congees
congers104223233congers
conges94928173con_ges
congius103210073congius
congo85623133congo__
congou94313243congo_u
conics103920593con_ics
conies84338593con_ies
conines93827793conines
conins84327233con_ins
conioses10313313conioses
coniosis1048133coniosis
coniums11311863coniums
conjoin1638203conjoin
conjoins1738133conjoins
conkers133721043conkers
conks115525703con__ks
conky145818743con_ky_
conners94023113conners
connote9311613connote
connotes10311453connotes
conns75024233con__ns
conoid9818883con_oid
conoids10813883conoids
cons66057693con___s
consol82614113conso_l
console92715983console
consoles103216153consoles
consort91319903consort
consorts101512343consorts
consuls92412313consuls
contes84432913con_tes
conto76027173conto__
contort91422343contort
contorts101112643contorts
contour939973contour
contours1039653contours
contras93015623contras
controls10311393controls
conus76726533con__us
convect143114483convect
convects153410993convects
convene123314323convene
convenes132916913convenes
convenors14277633convenors
convent123919413convent
convents132614603convents
converse13310263converse
converso1336423converso
convert123721473convert
converts133213553converts
convex18367743conv_ex
convexes20278273convexes
conveyed17247923conveyed
conveyer16278143conveyer
conveyers17267203conveyers
conveyor16245293conveyor
conveyors17235523conveyors
convict143410983convict
convicts15337713convicts
convoked18236163convoked
convoker17226903convoker
convokers18246103convokers
convolve1644653convolve
convolves1745323convolves
convoying1835983convoying
convulse1345443convulse
cony96537833con__y_
cooeys114914483co_oeys
coofs105924713co__ofs
cookeys16478503cookeys
cooks115429143co__oks
cools75632633co__ols
coons76737283co__ons
coops96229643co__ops
coos67456493co__o_s
coots75636843co__ots
copays134911273co_pays
copious11311963copious
coplots11511593coplots
copyboys2042663copyboys
cordons104415763cordons
cormous11312353cormous
corncobs1444723corncobs
corneous10310033corneous
cornrows1345313cornrows
corvees124613793corvees
corves115122523corv_es
corvets124715023corvets
corvids1337683corvids
coseys115215813co_seys
cosmos10311753cosmo_s
cottons9312193cottons
coupons112710563coupons
covens114919263co_vens
covers114627963co_vers
coves105539173co_v_es
covets114819643co_vets
covey136121783co_vey_
covins114618063co_vins
cowboy1637063cowboy_
coydogs1434493coydogs
coypous14248813coypous
coys97537243c___oys
cozeys204610913co_zeys
donjons1536733donjons
donkeys15426663donkeys
donors75115793don_ors
enjoys1644603_enjoys
envois988703_envois
envoy1156723_envoy_
gonofs10459863gon_ofs
honeys124016083hon_eys
honkeys17439513honkeys
honors94816793hon_ors
lowboys1534213lowboys
mondos95217333mondo_s
moneys115513623mon_eys
mongoes103415713mongoes
mongols103310823mongols
mongos94318623mongo_s
monkeys16407423monkeys
monos75930863mon_o_s
noncoms1139203noncoms
nongays11176533nongays
onions64016433_onions
onlays9398713_onlays
onos46229003_on_o_s
poboys1397313po_boys
pontons93315553pontons
potboys1475273potboys
reconveys1743533reconveys
renvois1036503renvois
rondos74616733rondo_s
ronions73313343ronions
ronyons10258433ronyons
savoys12427893_savoys
tannoys1055553tannoys
tomboys1435713tomboys
tondos75115923tondo_s
wontons103310533wontons

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 Limit1340272315.89022755.0
3Display Results2312310.0763039.5
 (SQL Overall)1786912316.37228043.2
 
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.