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 “crocus” with Change Limit: [1] [2] [3]

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
crocus10481317(None) 
crocks145118421crocks
crocs95722431croc_s
arcus76918862ar_cus
brocks145214152brocks
carolus94612602carolus
caucus1039612caucus
cercus105013152cercus
cerous85821202cero_us
chocks174815312chocks
chorus115014772chorus
circus104310592circus
clocks144916232clocks
clonus85212412clonus
cocas95926572c_ocas
coccus979282coccus
cocks135227162c_ocks
cocos95624692c_ocos
conus76726532c_onus
cornus84816562cornus
corpus106015292corpus
cracks144817002cracks
cricks144316052cricks
croaks125812982croaks
croc85723732croc__
croci95818132croc_i
crock135921992croc_k
crocuses1239022crocuses
crofts114910592crofts
crones84729242crones
crooks124914412crooks
croons85418422croons
crops96125232cro_ps
croquis1834762croquis
crores86121162crores
cross75124502cro_ss
crouch133910202crouch
croup95616782cro_up
croups104312552croups
crouse84619362cro_use
crowds124910762crowds
crowns115615112crowns
crows105727312cro_ws
crozes174417662crozes
cruces105117542cruces
crucks144412582crucks
crus65828482cr__us
cuscus1038112cuscus
focus105815882_focus
frocks154111212frocks
hocus104715202_hocus
locus74819992_locus
rocks114626412_rocks
rocs65533662_roc_s
trocks123614632trocks

Search took 3 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 Filter178691825510.326548131.9
2DLD Change Limit82551552.20337472.1
3Display Results55550.0163437.5
 (SQL Overall)178691552.54570212.6
 
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.