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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

33 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
rechannelled185146(None) 
rechanneled1752221rechanne_led
channelled1644142__channelled
chandelled1744273__chandelled
channeled1544913__channe_led
mischannelled2161113mischannelled
precancelled1951593prec_ancelled
rechannel1444323rechanne_l__
rechanneling1852453rechanneling
rechannelling1951423rechannelling
rechannels1543183rechanne_l_s
repanelled1343403re_pa_nelled
unchanneled1752473unchanne_led
cancelled1456744__c_ancelled
chandelle1545224__chandelle_
chandelles1645344__chandelles
channeler1444604__channe_ler
channelized2652604__channelized
empanelled1542494_empa_nelled
flannelled1442844__flannelled
hanselled1345484___hanselled
kennelled1443514ke___nnelled
mischanneled2061594mischanne_led
precanceled1852454prec_ance_led
reannexed1743064re__anne_xed
recalled11310804rec_a___lled
rechallenged1971334rechallenged
rechanged1646854recha_n__ged
rechartered17153164recharte_red
reconnected1665104rec_onnected
rehandled1444764re_ha_n_dled
relabelled1342864re_la_belled
repaneled1245334re_pa_ne_led

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 Filter1786911247900.390458182.1
2DLD Change Limit124790337.31317064.1
3Display Results33330.0162062.5
 (SQL Overall)178691337.71923149.5
 
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.