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 “capriole” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
capriole127691(None) 
cabriole1276931cabriole
caprioled1464741caprioled
caprioles1376751caprioles
cariole9818341ca_riole
carriole1089861carriole
cabrioles1376362cabrioles
cabriolet1377482cabriolet
caprice1349682capri_ce
caprine11314232capri_ne
carioles10817072ca_rioles
carrioles1169472carrioles
dariole8711162da_riole
variole10711592va_riole
airhole1048273_airhole
areole61017283_a_reole
ariose64818723_a_riose
aureole738693_aureole
auricle9139813_auricle
cabrilla1245833cabrilla
cabriolets1463373cabriolets
cajole154011183ca__jole
calcicole1244443calcicole
calicle113111433ca_licle
calliope1256223calliope
camisole1246173camisole
canaille1048413canaille
canticle1239703canticle
capable13313363cap_able
capitol11258283capitol_
capitols12247333capitols
capote10315733cap__ote
capric12411803capri__c
capricci1342653capricci
caprices1439893caprices
caprifig1643223caprifig
caprioling1544523caprioling
capris10415083capri__s
caprock1736813capr_ock
capsize2037623capsi_ze
capstone1237653capstone
capsule1137343cap_sule
caption113513693captio_n
captioned1445763captioned
captions123813223captions
captious122810573captious
captive1438973capti_ve
caracole12310353caracole
caribe103416753ca_ri_be
carinae94318583ca_rinae
carioca1139683ca_rioca
carious93320283ca_rious
carle74535703ca_r__le
carol75128613ca_r_ol_
caroled103717693ca_r_oled
caroler93816753ca_r_oler
caroli85918233ca_r_oli
carols85124983ca_r_ols
carpale113414353ca_rpale
carpool1139223carpool_
carpooled1445073carpooled
carpooler1345313carpooler
carpools1237883carpools
carriage1137853carriage
carrion9312673carrio_n
carrions10312453carrions
caulicle1245043caulicle
centriole1145673centriole
coprince1447093coprince
creole8913733c__reole
cuprite1159683cupri_te
curricle12145933curricle
darioles9710693da_rioles
gloriole944303gloriole
lapsible1273973lapsible
oriole6814293__oriole
ovariole1144923ovariole
parole84425253pa_r_ole
prole74527793__pr_ole
safrole1037253safr_ole
saprobe1137333sapr_obe
scariose1037593sca_riose
taphole1239773tap_hole
variola1068893va_riola
varioles11711123va_rioles

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 Filter1786911461620.406440125.6
2DLD Change Limit146162856.73621698.6
3Display Results85850.0302833.3
 (SQL Overall)178691857.17224915.1
 
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.