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

184 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
carboras1231157(None) 
carbora11310701carbora_
arbores94016032_arbores
arbors84717872_arbor_s
carbarns1238562carbarns
carbonaras1444442carbonaras
carbons115418942carbo_ns
carbos105122262carbo__s
carboys144711782carbo_ys
cariocas1239662cariocas
carports1238942carports
harbors12412412harbor_s
rasboras1045892rasboras
abomas101113583_a_bomas
aboral8314373_a_boral
aborts84916183_a_borts
acarboses1345083acarboses
agoras7613343_a_goras
angoras8811363_angoras
arbor74818113_arbor__
arboreal1045633_arboreal
arbored103811603_arbored
arborist10411613_arborist
arborous1047713_arborous
arbours93910033_arbours
ardors74416863_ardor_s
areolas71013863_areolas
armors85017813_armor_s
aromas81018613_ar_omas
arras55626133_ar__ras
arrobas969213_arrobas
auroras7311703_auroras
balboas113710073balbo_as
bandoras1138743bandoras
barbers114317503barber_s
boras75938303___boras
cabalas113516003ca_balas
cabanas112413033ca_banas
cabbalas1467373cabbalas
cabers105023903ca_ber_s
cabobs124311883ca_bo_bs
cabombas1643813ca_bombas
caeomas1138393ca_eomas
caesuras1055723caesuras
calderas1147863calderas
cambers134017433camber_s
cambogias1643843cambogias
cameras11313343ca_meras
camorras12116493camorras
candors104216763candor_s
canolas9313993ca_nolas
cantors94620753cantor_s
canzonas1935383canzonas
caporal11410943ca_poral
caporals1238923ca_porals
captors113914983captor_s
capybaras1842573capybaras
caracaras1346843caracaras
carambolas1643363carambolas
carbarn1139453carbar_n
carbaryl1544423carbaryl
carbaryls1644013carbaryls
carbides133111693carbides
carbines123617533carbines
carbo94923843carbo___
carbolic1448323carbolic
carbolics1546723carbolics
carbon104919043carbo__n
carbonade1446543carbonade
carbonades1546113carbonades
carbonado1444383carbonado
carbonados1543793carbonados
carbonara1345053carbonara
carbonate13410513carbonate
carbonates1449133carbonates
carbonic1439993carbonic
carbonous1347063carbonous
carbonyl1595383carbonyl
carbonyls1675033carbonyls
carboxyl22103633carboxyl
carboxyls2363693carboxyls
carboy134914183carbo__y
carboyed1637183carboyed
carbs96031463carb___s
carburet12411103carburet
carburets1345203carburets
carburise1345803carburise
carceral1247193carceral
cardboard1545863cardboard
cardboards1645333cardboards
carders104820353carder_s
cardias10715093car_dias
cardons104519933cardo_ns
cardoons113411943cardoons
careers95218783career_s
carers85133953car_er_s
carfares13310323carfares
cargoes104415223cargo_es
cargos94619183cargo__s
carhops14329703carho_ps
caribous1258823caribo_us
carinas93622383car_inas
carioca1139683carioca_
carioles10817063carioles
carious93320283cario_us
caritas93316943car_itas
carload1039783carlo_ad
carloads1138393carloads
carobs104818103car_o_bs
carols85124983car_o_ls
carolus94612603car_olus
caroms105619573car_o_ms
carpers114521253carper_s
carpools1237883carpools
carport11316033carpor_t
carroms11512403carro_ms
carrots9714623carro_ts
carrs75730853car__r_s
carters95327243carter_s
cartogram1445503cartogram
cartograms1545113cartograms
cartons94122473carto_ns
cartoons104012803cartoons
carvers124817533carver_s
cascaras1237693cascaras
castors94919433castor_s
catbirds1344193catbirds
catboat11412243catbo_at
catboats1247863catboats
cavorts1237933ca_vorts
chromas142512683chr_omas
cobras104014193c_ob_ras
corbinas12229383corbinas
cordobas1345793cordobas
coronas93916903cor_onas
corpora1139353corpora_
corporal1248513corporal
corporals1347273corporals
crabgrass1441963crabgrass
crapolas1247403crapolas
crores86121163c_r_ores
cruors838623c_ruor_s
curaras93911943cur_aras
curbers115514373curber_s
cursors93910023cursor_s
cyborgs1542763c_yborgs
darbars10510093darbar_s
earworms1346763earworms
garboard1247243garboard
garboards1346363garboards
garboils1145663garboils
gerberas1144943gerberas
harbor11410723harbor__
harborage1544653harborage
harborages1644513harborages
harbored1438633harbored
harborer1348053harborer
harborers1446913harborers
harborous1445483harborous
harbours1346903harbours
jerboas1636163jerbo_as
labors84016403la_bor_s
larboard1157663larboard
larboards1246983larboards
marjoram1944143marjoram
marjorams2043003marjorams
narcomas1246043narcomas
pakoras1337473pa_koras
pandoras11310053pandoras
parabolas1347003parabolas
parboils1237433parboils
pareiras1038183pareiras
parlors9312913parlor_s
paruras9310533par_uras
rasbora945943rasbora_
sabras85116363sa_b_ras
sarcomas1247223sarcomas
sartors7314953sartor_s
tabors84517093ta_bor_s
tambouras1343473tambouras
tamburas12316043tamburas
variolas1168533variolas
warlords1245303warlords
warworks1877063warworks

Search took 10 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 Limit1461621848.72016761.7
3Display Results1841840.1101672.7
 (SQL Overall)1786911848.98619885.5
 
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.