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

81 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
cornus8481656(None) 
conus76726531co_nus
corns76034761corn_s
cornu75921321cornu_
cornua85411901cornua
corpus106015291corpus
acorns85013012acorn_s
bonus75324322bo_nus
carns75937562carn_s
carpus105514302carpus
cercus105013152cercus
cereus85215522cereus
cerous85821202cerous
chorus115014772chor_us
circus104310592circus
cirrus8349172cirrus
clonus85212412clonus
cobnut10311322cobnut
cobnuts1135352cobnuts
coccus979282coccus
coins75834552coin_s
coitus8511892coitus
coleus86818272coleus
colonus94413442colonus
comous10816502comous
cones76457422co_nes
conks115525702co_nks
conns75024232co_nns
cons66057692co_n_s
coons76737282coon_s
corals85325142corals
cords86030622cor_ds
corers85231072corers
cores76361852cor_es
corgis9314412corgis
corium10315722corium
corks116028272cor_ks
cormous11312352cormous
corms95626222cor_ms
corn69945812corn__
cornea84018922cornea
corneas94717002corneas
corned95224522corned
cornel84020052cornel
cornels94716662cornels
corneous10310032corneous
corner84625622corner
corners94723312corners
cornet84436732cornet
cornets94820572cornets
cornhusk1742042cornhusk
cornual94210172cornual
cornuses10310032cornuses
cornute939642cornute
cornuto937032cornuto
cornutos1046052cornutos
corny106023272corn_y
coronas93916912coronas
corps95927042cor_ps
cors66656442cor__s
corses84433462corses
corves115122522corves
counts84618272counts
coypus13389302coypus
crocus104813172crocus
crones84729242crones
crus65828482c_r_us
curns74924282curn_s
horns86125332horn_s
morns75527442morn_s
onus45826812_o_nus
ornis54616772_ornis
pornos85015252pornos
porns75527342porn_s
porous84419482porous
scorns85713022scorn_s
sorns55028422sorn_s
sorus54527582sor_us
tonus56324302to_nus
torous64319032torous
torus54329762tor_us

Search took 4 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.376475242.0
2DLD Change Limit82551812.64031269.3
3Display Results81810.0302700.0
 (SQL Overall)178691813.04658664.1
 
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.