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

197 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
auricle913981(None) 
auricled11135701auricled
auricles10138331auricles
article9310922article
audible10228242audible
audile73315302audi_le
aureole738692aureole
auric74521722auric__
auricula1045802auricula
auriculae1145162auriculae
caulicle1245042caulicle
cubicle1337002cubicle
curricle12145932curricle
cuticle1138232cuticle
funicle12237482funicle
tunicle9308032tunicle
utricle937912utricle
abridge1135693abridge
acridly13396533acridly
addible11236063addible
advice12107883advic_e
aedile73716653aedi_le
aerial64625713aerial_
aerials74017553aerials
aerie54634603aeri__e
aerily93017013aeri_ly
affiche1844313affiche
agile65122263a_gi_le
airhole1048273airhole
airily93014823airi_ly
aisle55223193a__isle
alible8311973a_lible
amice96122863a_mic_e
anile54634463a_ni_le
anticly12410053anticly
anuric8812093anuric__
apricot111010183apricot
arable81821003a_rable
areole61017283a_reole
argle65421563a_r_gle
argyle1066063a_rgyle
aridly105513703a_ridly
ariel55228973a_riel_
ariels65119373a_riels
aril45843023a_ri_l_
ariled75620323a_ri_led
arils58732203a_ri_ls
ariose64818723a_riose
arise56436433a_ri_se
arrive91311793arri_ve
articled1137063articled
articles10310243articles
atrial65418943atrial_
audial7312993audial_
audibled12224093audibled
audibles11215533audibles
audibly13216043audibly
audiles83112613audi_les
auditee8311573auditee
augite7312613augi_te
aulic74420243aulic__
aurae54128113aur__ae
aural54428963aur_al_
aurally10310533aurally
aurate64426473aur_ate
aureate72515283aureate
aureola747033aureola
aureolae845313aureolae
aureoled945733aureoled
aureoles838283aureoles
auricular1146313auricular
auriculas1146053auriculas
auriculate1246493auriculate
auris55331523auri__s
aurist65027253auri_st
aurists74615783aurists
aurochs1245983aurochs
aurorae739663aurorae
auspice1136523auspic_e
avarice1238033avaric_e
awhile1257793awhi_le
axile126020513a_xi_le
azurite1638003azuri_te
bernicle1245443bernicle
brickle15279933_brickle
bricole112810493_bricole
bridle94115463_bridle
burble104617703bur_ble
burgle94815863bur_gle
burial84117623burial_
burials93612083burials
cabriole1276933cabriole
calicle113111433calicle
canticle1239703canticle
caprice1349683capric_e
capriole1276913capriole
cariole9818343cariole
carriole1089863carriole
caruncle1244713caruncle
caulicles1344383caulicles
chicle134312543_chicle
circle1039703cir_cle
coracle112011723coracle
cornicle1258783cornicle
cubicles1435883cubicles
cubicly1644993cubicly
curable112414513curable
curdle95514313cur_dle
curiae84518373curi_ae
curial84019153curial_
curie74533033curi__e
curite85222943curi_te
curlicue1243223curlicue
curricles13105423curricles
curule83614123cur_ule
cuticles1237893cuticles
dariole8711163dariole
durable102312723durable
fascicle1554633fascicle
funicles13246833funicles
furuncle1342153furuncle
fusible1237023fusible
fusile94313493fusi_le
futile93914953futi_le
grille74315743_grille
guile64521133gu_i_le
gurgle83912473gur_gle
hurdle103712793hur_dle
hurtle93512943hur_tle
icicle1036583_icicle
jubile152910253jubi_le
juice14311323ju_ic_e
loricae938253loricae
luridly1196283luridly
miracle1138843miracle
muriate9313363muriate
muricate12311113muricate
murices112612283murices
murine84220023muri_ne
muscle10310973mu_scle
musicale1247343musicale
nubile83212703nubi_le
nuncle839363nu_ncle
oracle84313293_oracle
oriole6814293_oriole
orrice81410163orric_e
ossicle944483ossicle
ourie54027293ouri__e
panicle11129983panicle
particle1239533particle
pedicle1238963pedicle
price93725413_pric_e
prickle153611013_prickle
puerile9310093pueri_le
pumice1238223pumic_e
purfle112511183pur_fle
purine85321893puri_ne
purple102712673pur_ple
quiche2057903qu_iche
radicle103510713radicle
reticle94112623reticle
rice64942913__ric_e
rifle85518333__rifle
rile45650533__ri_le
rille55728733__rille
rutile65217683ruti_le
sanicle91210263sanicle
silicle937753silicle
strickle1467793strickle
suricate10312613suricate
surtitle845283surtitle
taurine7311363tauri_ne
thrice114311573thric_e
thurible1343353thurible
trice75127493_tric_e
trickle133613443_trickle
trifle94012883_trifle
triple84215923_triple
tuille63012643tu_ille
tunicae9328143tunicae
tunicles10217133tunicles
turtle63213573tur_tle
uncle7317053_u_ncle
urial54823023_urial_
urials64415193_urials
uric63624933_uric__
urine55026593_uri_ne
utile54718933_uti_le
utricles1037223utricles
variole10711593variole
vehicle15175253vehicle
vernicle1346433vernicle
versicle1366583versicle
vesicle12217923vesicle
virile9313433viri_le
wavicle1534063wavicle
zorille1636673zorille

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.1401276364.3
2DLD Change Limit1340271975.97022450.1
3Display Results1971970.0802462.5
 (SQL Overall)1786911976.19028867.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.