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

92 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
caponiers134573(None) 
caponier1237881caponier_
canonizers2144412canonizers
caponizes2238702caponizes
agonies83016623_agonie_s
appliers1235573_appliers
atoners75013953_aton_ers
atonies75320953_atonie_s
baronies10315023baronie_s
cahiers123510673ca__hiers
cajolers17267133cajo_lers
cajones163311333cajon_e_s
calenders1237403calenders
calories102919553calorie_s
caloyers1337343calo_yers
cancers114018583ca__ncers
caners84629203ca__n_ers
cankers134418753ca__nkers
canners93822663ca__nners
cannier94014163ca_nnier_
cannoneers1243323cannoneers
canoers94318373ca__noers
canoness1039393canon_ess
canonises11410803canonises
canonists1158513canonists
canonizer2046693canonizer_
canonizes2049593canonizes
canonries1148413canonrie_s
canopies12311853canopie_s
canters94827733ca__nters
canyoneers1542943canyoneers
caperers122611723cap_erers
capers105428143cap___ers
capmakers1944723capmakers
capoeira1243353capoei_ra
capoeiras1343183capoeiras
caponatas1343903caponatas
caponize2139113caponi_ze
caponized2347073caponized
capons104119503capon___s
capotes11314643capo_te_s
cappers134419403cap__pers
capsomers1544753capsomers
capturers1344633capturers
carnies94123963ca_rnie_s
carolers103314173caro_lers
carollers1137703carollers
carousers1156743carousers
carpenters1445843carpenters
carpoolers1444573carpoolers
carriers103614203ca_rriers
cashiers13318883ca_shiers
catbriers1344143catbriers
cavaliers1455623cavaliers
cavorters1434973cavorters
ciphonies1646543ciphonie_s
cloners94514823c_lon_ers
coiners93620753c__oiners
colonies103620013colonie_s
colonizers21286723colonizers
confers124120093c__onfers
congers104223233c__ongers
conies84338593c__onie_s
conifers133611703c__onifers
conkers133721043c__onkers
conners94023113c__onners
copiers114215963c__opiers
coroners104016223coron_ers
crayoners1444503crayon_ers
cronies9622503c_ronie_s
crooners103911393croon_ers
crosiers103312063c_rosiers
croziers19287003c_roziers
gasoliers1044203gasoliers
japanners1842813japanners
japonicas20113253japonicas
paniers94717333__paniers
panniers10488853pa_nniers
ponders103618843__ponders
ponies84833463__ponie_s
rapiers95012873rap__iers
saponifiers1651863saponifiers
saponines1148043saponines
saponins1039453saponi_ns
saponites1139943saponites
saxonies1537913saxonie_s
spongers1137603_spongers
vaporers1336243vapo_rers
vaporizers24244113vaporizers
vapourers1443373vapourers
wagoners1235473wagon_ers
weaponeers1542003weaponeers

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 Filter1786911486410.436409841.7
2DLD Change Limit148641926.34323433.9
3Display Results92920.0332787.9
 (SQL Overall)178691926.81226231.8
 
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.