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

33 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
camellias136509(None) 
camelias12510301came_lias
camellia1255441camellia_
camelia11510432came_lia_
camelids1356942came_lids
camellike1745062camellike
canellas10310562canell_as
lamellas1098162lamell_as
abelias93213563_abe_lias
amentias1039413_amentias
bumelias1245063bume_lias
cadelles1139973cadell_es
callas84526753ca__ll_as
cambogias1643853cambogias
cameleers1345093cameleers
camelhair1651953camelhair
camelhairs1751853camelhairs
camelid1249413came_li_d
camels105217083came_l__s
cameras11313363came__ras
camisias12268603cam_isias
canella9310793canell_a_
capelins12311133cape_lins
capellini1345263capellini
cavallas1366843cavall_as
cavallies1446393cavallies
favellas1446163favell_as
lamella988613lamell_a_
lamellae10117033lamell_ae
lamellar1096493lamell_ar
paellas9411413pa_ell_as
patellas1039103patell_as
ramillies1146133ramillies

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.423422437.4
2DLD Change Limit148641336.76621968.8
3Display Results33330.0132538.5
 (SQL Overall)178691337.20224811.3
 
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.