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

128 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
carriole108986(None) 
cabriole1276931cabriole
capriole1276911capriole
cariole9818341ca_riole
carrioles1169471carrioles
cabrioles1376362cabrioles
cabriolet1377482cabriolet
caprioled1464742caprioled
caprioles1376752caprioles
caracole12310352caracole
carioles10817072ca_rioles
carriage1137852carriage
carrion9312672carrio_n
carrions10312452carrions
curricle12145932curricle
dariole8711162da_riole
variole10711592va_riole
airhole1048273_airhole
areole61017283_a_reole
ariose64818723_a_riose
armhole1236943_armhole
arrive91311793_arri_ve
arteriole945893_arteriole
article9310923_article
aureole738693_aureole
auricle9139813_auricle
barrable1249243barrable
barrio8312573barrio__
barrios9310773barrio_s
braciole1246973braciole
cabrilla1245833cabrilla
cabriolets1463373cabriolets
cajole154011183ca__jole
calcicole1244443calcicole
calicle113111433ca_licle
calliope1256223calliope
camisole1246173camisole
canaille1048413canaille
canticle1239703canticle
caprice1349683capri_ce
caprine11314233capri_ne
caracol11310423caracol_
caracoled1445983caracoled
caracoler1346413caracoler
caracoles13310073caracoles
caracols12310413caracols
carbazole2243773carbazole
carbide126112493carbi_de
carbine112918643carbi_ne
carbinol1245773carbinol_
carbinols1346113carbinols
cardiae10713703cardi_ae
cardio9915673cardio__
cardioid1247443cardioid
caribe103416753ca_ri_be
carinae94318583ca_rinae
carioca1139683ca_rioca
carious93320283ca_rious
carle74535703ca_r__le
carline93923613carli_ne
carmine112918483carmi_ne
carnie84421093carni__e
carnivore1443413carnivore
carol75128613ca_r_ol_
caroled103717693ca_r_oled
caroler93816753ca_r_oler
caroli85918233ca_r_oli
carols85124983ca_r_ols
carpale113414353ca_rpale
carpool1139223carpool_
carpooled1445073carpooled
carpooler1345313carpooler
carpools1237883carpools
carrel84718633carr_el_
carrell94610473carr_ell
carrells10359273carrells
carrels95117303carr_els
carriages1238333carriages
carried103717153carri_ed
carrier93619583carri_er
carriers103614203carriers
carries94328013carri_es
carritch1543483carritch
carroch1437093carr_och
carrom10513403carr_o_m
carromed1338563carr_omed
carroms11512403carr_oms
carrot8423123carr_o_t
carrots9714623carr_ots
carroty1248943carr_oty
carryall1343913carryall
carryon1237033carryo_n
carryons1337103carryons
carryout1346783carryout
carryover1742733carryover
cartable121314093cartable
cartridge1372723cartridge
caruncle1244713caruncle
caulicle1245043caulicle
centriole1145673centriole
cirrose937473cirr_ose
cornicle1258783cornicle
corrie83621223corri__e
corrode101310573corr_ode
creole8913733c__reole
curricles13105423curricles
currie84317263curri__e
darioles9710693da_rioles
garrote8510103garr_ote
gloriole944303gloriole
horrible13135233horrible
marriage1147253marriage
nargile847653nargi_le
oriole6814293__oriole
ovariole1144923ovariole
parole84425253pa_r_ole
parridge1254333parridge
partible1238063partible
particle1239533particle
pyrrole1246033pyrr_ole
safrole1037253safr_ole
scariose1037593sca_riose
scurrile1055073scurri_le
terrible1046643terrible
variola1068893va_riola
varioles11711123va_rioles
warrior1045363warrio_r
warriors1135363warriors

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.423422437.4
2DLD Change Limit1461621288.59317009.4
3Display Results1281280.1101163.6
 (SQL Overall)1786911289.12619580.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.