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

239 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
dariole871116(None) 
cariole9818341cariole
darioles9710691darioles
variole10711591variole
areole61017282_areole
ariose64818722_ariose
cabriole1276932cabriole
capriole1276912capriole
carioles10817062carioles
carriole1089862carriole
darkle113813942dar_kle
dartle73714832dar_tle
oriole6814292_oriole
ovariole1144912ovariole
parole84425252par_ole
variola1068892variola
varioles11711122varioles
addible11236063addible
agile65122263_agi_le
aioli5318313_a_ioli
airhole1048273airhole
aisle55223193_a_isle
alible8311973_alible
amole75724593_a_mole
anile54634463_ani_le
anisole71010833_anisole
anole55330373_a_nole
arable81821003_arable
areola6813673_areola
areolae7811733_areolae
areoles71016953_areoles
argle65421563_ar_gle
argol65317263_argol_
argols74514613_argols
argyle1066063_argyle
aridly105513703_aridly
ariel55228973_ariel_
ariels65119373_ariels
aril45843023_ari_l_
ariled75620323_ari_led
arils58732203_ari_ls
ariosi64313033_ariosi
arioso64312403_arioso
arise56436433_ari_se
arkose104911343_arkose
armhole1236943_armhole
arose55832083_ar_ose
article9310923_article
aureole738693aureole
auricle9139813auricle
axile126020513_axi_le
azole145118033_a_zole
barbule1137943barbule
barilla9310323barilla
barite84224813bari_te
baritone1058643baritone
braciole1246973braciole
braille939713braille
bricole112810493_bricole
bridle94115463_bridle
cabrioles1376363cabrioles
cabriolet1377483cabriolet
cajole154011183ca_jole
calicle113111433calicle
camisole1246173camisole
caprioled1464743caprioled
caprioles1376753caprioles
caracole12310353caracole
caribe103416743cari_be
carinae94318583carinae
carioca1139683carioca
carious93320283carious
carle74535703car__le
carol75128613car_ol_
caroled103717683car_oled
caroler93816753car_oler
caroli85918233car_oli
carols85124983car_ols
carpale113414353carpale
carrioles1169473carrioles
creole8913723_creole
dabble114515193da_bble
dacite91115883daci_te
daddle94214283da_ddle
daggle93711903da_ggle
daily95922333da_i_ly
dale55643983da___le
dandle84218093da_ndle
dangle84119303da_ngle
danio6319783danio__
danios7314603danio_s
dapple1138853da_pple
dapsone1038463dapsone
dare55848863dar___e
daric85623113dari__c
darics94314113dari_cs
daring84928683dari_ng
daringly1348573daringly
darings93713643darings
darkie113714013dar_kie
darkled13378713dar_kled
darkles124011933dar_kles
darkly145411073dar_kly
darksome1544043darksome
darnel74312183darnel_
darnels83710433darnels
dartled9409853dar_tled
dartles84014133dar_tles
datable101714233datable
dative10311813dati_ve
dawdle11399503da_wdle
dazzle1536853da_zzle
dearie73319813deari__e
decile94619213deci_le
defile105216663defi_le
deride84420033deri_de
derive103817043deri_ve
dhole95215363d__hole
diastole947563diastole
diazole1736793diazole
diode74716113d__iode
diol57329133d__iol_
diols65521013d__iols
dipole91112853d_ipole
docile94213123doci_le
dole56550003d___ole
drabble12238883drabble
draggle1056103draggle
drail65020973drai_l_
drails74716953drai_ls
dribble12368603d_ribble
driblet103712243d_riblet
drill64718263d_ri_ll
drilled94711673d_rilled
driller84311883d_riller
drills74414203d_rills
drily95816523d_ri_ly
drive95318003d_ri_ve
drivel105110383d_rivel
drizzle16285913d_rizzle
droll65415403d_r_oll
drone65324983d_r_one
drool65416103d_rool_
drooled9369203d_rooled
drools74412813d_rools
drooly104911073d_rooly
drove95518063d_r_ove
durable102312723durable
durion7510963durio_n
durions839963durions
earlobe946543earlobe
facile112514883faci_le
faille93414743fa_ille
farinose1136463farinose
farle86929243far__le
frijole1734583_frijole
garble94118453gar_ble
gargle84215463gar_gle
gargoyle1342503gargoyle
garigue935583garigue
garote7717943gar_ote
garrote8510103garrote
gloriole944303gloriole
grille74315743_grille
habile11515203habi_le
haole84820083ha__ole
karaoke1044903karaoke
labile8315213labi_le
larine63927043lari_ne
liriope944043liriope
maile75232213ma_i_le
manhole12311343manhole
manille92613273manille
maniple11249653maniple
marble104219103mar_ble
marigold1244093marigold
marine84230403mari_ne
maypole1446383maypole
narcose95910383narcose
nargile847653nargile
narial6317953narial_
narine63422553nari_ne
orioles7412993_orioles
ostiole739013ostiole
ovarioles1244603ovarioles
panicle11129983panicle
parable111819773parable
parle75836163par__le
parol74826273par_ol_
paroled104217613par_oled
parolee94119633par_olee
paroles95025883par_oles
parols84722613par_ols
partible1238063partible
particle1239533particle
petiole9311303petiole
prole74527793_pr_ole
pyrrole1246033pyrrole
radiale83813523radiale
radicle103510713radicle
rampole1139693rampole
rathole10312053rathole
ravioli1055613ravioli
rifle85518333__rifle
rile45650533__ri_le
rille55728733__rille
role45851823__r_ole
safrole1037253safrole
sanicle91210263sanicle
sarode75317513sar_ode
scariose1037593scariose
tadpole1036143tadpole
taille63116923ta_ille
taphole1239773taphole
trifle94012883_trifle
triode75311893_triode
triol55521363_triol_
triolet73219523_triolet
triols66117803_triols
triose64715383_triose
triple84215923_triple
utricle937913utricle
vacuole1245373vacuole
vagile10310543vagi_le
variable13310063variable
variate101316433variate
varicose1346703varicose
variolar1176343variolar
variolas1168533variolas
variolate1248553variolate
variolite1248083variolite
various103113103various
virile9313433viri_le
warble113516603war_ble
warily122915093wari_ly
warsle93112923war_sle
warstle10328013warstle
wavicle1534063wavicle
zorille1636673zorille

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 Limit1340272397.15618729.3
3Display Results2392390.0763144.7
 (SQL Overall)1786912397.38824186.7
 
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.