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

52 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
charioting164572(None) 
charting142614192char__ting
clarioning1345182clarioning
caprioling1544523caprioling
caroling113317003c_ar_oling
caroming133312963c_ar_oming
carotin92216733c_ar_otin_
carotins102315583c_ar_otins
carpeting1439483c_arpeting
carroming1437683c_arroming
carrotin102210893c_arrotin_
carrotins11239963c_arrotins
carting104228283c_ar__ting
cartoning12311113c_artoning
caryotin13268353c_aryotin_
caryotins14248043c_aryotins
chagrining1743443chagri_ning
chagrinning1851593chagrinning
chaining142810783cha_i_ning
chairing143110773cha_i_ring
chamoising1855163chamoising
championing2152733championing
chanting143413533cha__nting
charcoaling1953183charcoaling
charging152910773char__ging
charing133721323char___ing
chariot12316213chariot___
charioted1595873chariot_ed
charioteer1552763charioteer
chariots1339393chariot__s
charities14312743chari_ties
charking183512613char__king
charming163012033char__ming
charring142913163char__ring
chartering16109253chartering
chatting142810143cha__tting
chaunting1555413cha_unting
cherishing1944833cherishing
chroming163410723ch_r_oming
clarifying1944853clarifying
cohabiting1844803cohabi_ting
cowriting1557323cowri_ting
garoting10510703_gar_oting
garroting1136953_garroting
habiting1437533_habi_ting
harboring1538263_harboring
harrowing1646443_harrowing
lariating10311793_lariating
nonrioting1146753nonrioting
parroting1239153_parroting
rioting82716393___rioting
variating13310953_variating

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 Filter1786911406030.860207780.2
2DLD Change Limit140603527.32619192.3
3Display Results52520.0301733.3
 (SQL Overall)178691528.21621749.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.