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

46 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
coenurus104413(None) 
coenures1048681coenures
coendures1245212coendures
coenure968152coenur_e
coenuri945452coenur_i
caesuras1055733caesuras
censures102211623c_ensures
census84310303c_en_sus
centres93817123c_entres
centrum1168603c_entrum
centrums1236913c_entrums
cernuous1055013cernuous
cesuras958693c_esuras
cobnuts1135353cobnu_ts
coenacts1246403coenacts
coendure1145463coendur_e
coendured1344093coendured
coequals1944303coequals
coexerts1734883coexerts
coiners93620753coiner_s
coinsures1136723coinsures
colours95913443colour_s
colures9315143co_lures
conatus9310463co_natus
concurs11311473concur_s
congius103210073co_ngius
congous103615083co_ngous
conjures17119913conjures
conners94023113conner_s
contras93015623co_ntras
conus76726533co_n__us
corneous10310033corneous
corners94723313corner_s
cornus84816563corn__us
cornuses10310033cornuses
cornutos1046053cornutos
cothurns1344523cothurns
cothurnus1441953cothurnus
courts84216173co__urts
coutures10311993coutures
cozeners19297783cozener_s
enures63919713__enures
eremurus1042733eremurus
oestrus7169583_oestrus
tenuous738483_tenuous
tenures7412013_tenures

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit146162467.81018714.7
3Display Results46460.0162875.0
 (SQL Overall)178691468.23221706.9
 
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.