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

135 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
carboyed163718(None) 
arbored103811602_arbored
carboy134914182carboy__
carboys144711782carboy_s
caroled103717692car_oled
caromed123713622car_omed
carromed1338562carromed
cartoned111312832cartoned
cowboyed1943372cowboyed
harbored1438632harbored
aboded104912513_a_boded
acarbose1244683acarbose_
acarboses1345083acarboses
alloyed11158033_alloyed
annoyed1185873_annoyed
arbores94016033_arbores
arboured1156253_arboured
armored102610473_armored
arrayed11117153_arrayed
arrowed1148113_arrowed
barbed115121313barb__ed
barbered13259543barbered
bareboned1445103bareboned
cabbaged1644383cabbaged
cabbed135416263ca_b_bed
cabined1239993ca_bined
cabled114819873ca_b_led
caboched1844043ca_boched
caboshed1634393ca_boshed
cajoled17428283ca_joled
caloyer1238143ca_loyer
cambered15129003cambered
cameoed1238383cameo_ed
cannoned11118143cannoned
canoed94618963ca_no_ed
cantoned111411523cantoned
caprioled1464743caprioled
caracoled1445993caracoled
carbide126112493carbide_
carbides133111693carbides
carbine112918643carbine_
carbines123617543carbines
carbo94923843carbo___
carbolic1448323carbolic
carbolized24177083carbolized
carbon104919043carbo__n
carbonade1446543carbonade
carbonado1444383carbonado
carbonated1547243carbonated
carbonic1439993carbonic
carbonized24157053carbonized
carbons115418943carbo_ns
carbonyl1595383carbonyl
carbonyls1675043carbonyls
carbora11310703carbo_ra
carboras12311583carboras
carbos105122263carbo__s
carboxyl22103633carboxyl
carboxyls2363693carboxyls
carburet12411113carburet
cardboard1545863cardboard
carded105424903car__ded
cared86050093car___ed
careened1139193careened
careered1139493careered
caressed1139163caressed
cargoes104415223cargo_es
carhopped1972763carhopped
caried94528693car__ied
cariole9818343cariole_
carioles10817073carioles
carked134024823car__ked
carload1039783carlo_ad
caroler93816753car_oler
carolled1138833carolled
carotid102014833car_otid
caroused1149253caroused
carped115923763car__ped
carpeted1338953carpeted
carpooled1445073carpooled
carried103717153car_ried
carted98631443car__ted
cartooned1246313cartooned
carved124320853car__ved
charioted1595863charioted
chromed153510923chr_omed
clarioned1245723clarioned
cloyed125111563c__loyed
convoyed17225553convoyed
corbeled1338373corbeled
cordoned12229613cordoned
corroded12147513corroded
coyed114623803c___oyed
crabbed14388873crab_bed
crayoned1435003crayoned
crooked143910943c_rooked
crooned103813343c_rooned
crowed124717303c_r_owed
curbed114615873curb__ed
farrowed1545283farrowed
forboded15215353forboded
gamboled1435873gamboled
garbed104815663garb__ed
garbled114512803garb_led
garboard1247243garboard
gargoyled1541993gargoyled
garoted9710133gar_oted
garroted1056783garroted
hamboned1637003hamboned
harborer1348053harborer
harboured1544313harboured
harrowed1556263harrowed
jargoned1735233jargoned
jawboned21133553jawboned
labored102810253la_bored
larboard1157663larboard
mamboed14417623mambo_ed
marbled123212113marb_led
marooned1138563marooned
marrowed1445973marrowed
narrowed1235203narrowed
parbaked1735503parbaked
parboiled1445223parboiled
pardoned12189333pardoned
parlayed1435823parlayed
parleyed1436243parleyed
paroled104217633par_oled
parroted1158843parroted
rawboned14114253rawboned
samoyed1335893sa_moyed
stroyed114110863str_oyed
tabooed10267383ta_booed
tabored102810563ta_bored
varoomed1445293varoomed
warbled133212163warb_led

Search took 9 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.453394461.4
2DLD Change Limit1461621357.53319402.9
3Display Results1351350.0462934.8
 (SQL Overall)1786911358.03222247.4
 
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.