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

55 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
cichlid154531(None) 
cichlids1643661cichlids
cichlidae1751682cichlidae
cached145419203cach_ed
cackled164613303cackled
cactoid12311033cactoid
camelid1249413camelid
cepheid1545433cepheid
chichi1637093chich_i_
chichis1737073chich_is
chid106626403__ch_id
child114516223__child
cicala10310053cical_a
cicalas1139303cicalas
cicale10314503cical_e
cicelies1269753cicelies
cicely1338833cicel_y
cilia73016763ci__lia
cinched153910863cinch_ed
cipolin1148783cipolin
circled1237583circled
cirsoid1038123cirsoid
cissoid1037343cissoid
cliched153711023clich_ed
coccid102910743coc_cid
coccoid11299283coccoid
cochair1446313cochair
cochin131313203coch_in
cochlea1435343cochlea
cockled163710823cockled
conchoid1688043conchoid
cricetid1345193cricetid
cricoid1239243cric_oid
cycled1436543cyc_led
cyclic1238033cyc_lic
cyclin1339273cyc_lin
cycloid1539283cycloid
icicled1234293icic_led
lichi104412953lich_i_
lichis115212593lich_is
lichted13268803lichted
lithoid1148773lithoid
miched143913393mich_ed
niched125514063nich_ed
nickled144010443nickled
orchid1289573orch_id
pickled164011883pickled
picolin11310883picolin
richly1438003richl_y
sialid7314943si_alid
sickled144713433sickled
sicklied1546583sicklied
tickled144313133tickled
trichoid1457813trichoid
xiphoid2045923xiphoid

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.390458182.1
2DLD Change Limit134027556.22021547.7
3Display Results55550.0163437.5
 (SQL Overall)178691556.62626968.2
 
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.