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 “chervils” 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
chervils164455(None) 
chervil1534951chervil_
cherries131812982cherries
chevies153511442che_vies
ervils948772__ervils
carvels124914593c_arvels
cavils114014393c__avils
ceils75019403c_e__ils
cercis104614493c_erci_s
cereals9313173c_ereals
cerias83321983c_er_ias
cervelas1344673c_ervelas
cervices1537133c_ervices
cervid1239323c_ervi_d
cervine122610803c_ervine
cervix1865163c_ervi_x
cervixes2054603c_ervixes
charily15310283char_ily
charlies133414233charlies
charnels13328173charnels
cheapies1539033cheapies
cheekily2053473cheekily
cheerily1655423cheerily
cheerios13317583cheerios
cheesily1654413cheesily
cheloids1438033cheloids
chemics16349583che_mics
cherish15310463cher_ish
cheroots1348193cheroots
chertier1387873chertier
chertiest1438793chertiest
cherts115617233cher__ts
cherubims1841773cherubims
cherubs1434553cher_ubs
chestily1645523chestily
chevied16357483che_vied
cheviot1546933che_viot
cheviots1643783che_viots
chevres15379793che_vres
chevrets16255323chevrets
chevrons1665463chevrons
chirpily1843773chirpily
chivies153412853ch_ivies
chivvies1954423chivvies
chorals124614113chor_als
choroids1438693choroids
churls115411073chur__ls
clergies1137903clergies
clerics1149333cler_ics
clerids1049093cler_ids
clevis1158963cle_vi_s
coevals1237873coe_vals
corvids1337683c_orvids
derails84216393_derails
devils104412813_de_vils
ervil8310303__ervil_
evils84114263__e_vils
gerbils1037303_gerbils
gherkins1643993gherkins
heavies132713873_heavies
heavily1665903_heavily
heils85222193_he__ils
herbals122710603_herbals
herdics13249523_herdics
herls85226433_her__ls
hermits12312143_hermits
hernias10310773_hernias
heroics122912003_heroics
heroins103518013_heroins
herries104025073_herries
kevils13358333_ke_vils
nervily1336863_nervily
perils84121853_per_ils
serails73318363_serails
servals103410743_servals
servile10310643_servile
sherifs13299683sher_ifs
sherries111812893sherries
sherris10168803sherri_s
thermals13518533thermals
thermels13607763thermels
thermits1338513thermits
weevils1384683_weevils
wherries14179023wherries
wherves16548053wherv_es

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.1731032896.0
2DLD Change Limit146162857.06320694.0
3Display Results85850.0302833.3
 (SQL Overall)178691857.26624592.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.