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

63 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
chicories168876(None) 
chiccories1643831chiccories
chickories2144361chickories
chivaries1757432chivaries
cicorees1246412c_icorees
hickories1845312_hickories
bicornes12307253_bicornes
calories102919553c_alories
chaconnes1644003chaconnes
chanceries1747653chanceries
chantries14310293chantries
cherries131812983ch_erries
chicaneries1853913chicaneries
chicanes1559373chic_anes
chichier1836023chic_hier
chichiest1936343chic_hiest
chichis1737073chic_hi_s
chickarees2163223chickarees
chickees19258513chic_kees
chicles143512503chic__les
chicory1735993chicor__y
chicos134614833chico___s
chigoes1338353chigo__es
chilies124218303chi__lies
chillies134113483chi_llies
chimblies1845033chimblies
chimeres153511313chimer_es
chinones13510473chino_nes
chipotles1643793chipotles
chippies17309753chi_ppies
chirres123812253chi__rres
chitties13310773chi_tties
chivalries1843963chivalries
chivarees1744383chivarees
chivaried1844053chivaried
chivies153412853chi__vies
chivvies1954423chi_vvies
chlorides15289753ch_lorides
chlorids14299673ch_lorids
chlorines142512353ch_lorines
chlorins132612883ch_lorins
chlorites142311963ch_lorites
chores114828023ch__or_es
chorines132917253ch__orines
chuckies1937703chuc_kies
cicelies1269753c_icelies
cicoree1149843c_icor_ee
clitorides1344443clitorides
clitoris1047873clitori_s
clitorises1246103clitorises
cricoids1347183crico_ids
hickies163614743_hic_kies
histories12412473_histories
ivories10310713__ivories
licorices1346353_licorices
priories10312453pri_ories
spiceries1349313spiceries
succories1347183succories
theories11311593th_eories
tricornes1146233tricornes
victories1448913_victories
whirries14136693whi_rries
wicopies1545983_wicopies

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641637.71619264.0
3Display Results63630.0331909.1
 (SQL Overall)178691637.90522604.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.