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

44 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
crocheting184470(None) 
cacheting1737152c_acheting
cricketing1944032cricketing
croqueting2243172croqueting
racheting1537792_racheting
rocketing1666972_rocketing
bracketing1945233bracketing
brothering1646033brothering
closeting1236183clo_seting
cockering1839693c_ockering
cocreating15310293c_ocreating
cohering142413843c_o_hering
colleting12311063c_olleting
competing163712463c_ompeting
concreting1539873concreting
corseting12312173c_orseting
coshering15510023c_oshering
cosseting1239543c_osseting
coveting141912313c_o_veting
crocein1138073croc_e_in_
croceine1248033croc_e_ine
croceins1238103croc_e_ins
crochet143616663crochet___
crocheted1745313crochet_ed
crocheter1645563crochet_er
crocheters1744513crocheters
crochets15359833crochet__s
crocking174313443croc__king
crouching1746383crouch__ing
docketing1785413_docketing
grommeting1642913grommeting
ochering14219393__ochering
pocketing1875853_pocketing
proceeding1644673proceeding
prochein1547523proche_in_
procreating1647693procreating
racketing1647873_racketing
ratcheting1643783ratcheting
rechewing1836493_rechewing
richening1546223_richening
ricocheting1952373ricocheting
roqueting1944603_roqueting
socketing1666383_socketing
tochering1537153_tochering

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 Filter1786911406030.826216332.9
2DLD Change Limit140603446.40621948.6
3Display Results44440.0331333.3
 (SQL Overall)178691447.26524596.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.