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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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
rechannelling195142(None) 
rechanneling1852451rechanne_ling
channelling1743992__channelling
chandelling1844453__chandelling
channeling1645203__channe_ling
mischannelling2271043mischannelling
precancelling2051743prec_ancelling
rechannelled1851463rechannell_ed
repanelling1443473re_pa_nelling
cancelling1547214__c_ancelling
changeling1745674__change_ling
channelizing2752854__channelizing
empanelling1662414_empa_nelling
flannelling1542834__flannelling
hanselling1445624___hanselling
kennelling1573864ke___nnelling
mischanneling2181454mischanne_ling
precanceling1952774prec_ance_ling
reannexing1843154re__anne_xing
recalling122211904rec_a___lling
rechallenging2071274rechallenging
rechanging1746044recha_n__ging
rechannel1444324rechanne_l___
rechanneled1752224rechanne_l_ed
rechannels1543184rechanne_l__s
rechartering1853544recharte_ring
reconnecting1745354rec_onnecting
rehandling1544454re_ha_n_dling
relabelling1442664re_la_belling
repaneling1345734re_pa_ne_ling
annealing1047455____annealing
annulling1045005____annulling
bechalking2244115becha___lking
bechancing2044445becha_n__cing
becudgelling195835bec_udgelling
canalling1239555__c_a_nalling
canceling14310165__c_ance_ling
cannelloni1252495__c_annelloni
changelings1843185__change_lings
channelize2453265__channe_lize
channelled1644145__channell_ed
chiselling1644685__ch_iselling
coannexing2083165__coanne_xing
cocounselling186855cocounselling
counselling1444405__counselling
crenelling1345685__c_renelling
detasselling1451705de_tasselling
disannulling1451745_disannulling
empaneling1573405_empa_ne_ling
enamelling1344315_e_na_melling
flanneling1443815__flanne_ling
funnelling1444245___funnelling
handselling1642825___handselling
hanseling1338065___hanse_ling
impanelling1652625_impa_nelling
kenneling1464085ke___nne_ling
kernelling1584145ke___rnelling
mechanizing2846105mecha_n_izing
panelling1239075___pa_nelling
prechilling1943745prech___illing
prehandling1853425pre_ha_n_dling
rappelling1544365r___appelling
ravelling13269245r___a_velling
rebelling122111165re____belling
recanalizing2446805rec_analizing
recaning111416695rec_a_n___ing
recanting122414825rec_a_n__ting
recarpeting1674365rec_arpe_ting
rechallenge1751805recha___llenge
recharging1745295recha___rging
recharting1637215recha___rting
rechecking2244465rech___ecking
rechewing1836495rech___e_wing
recoaling121312455recoa____ling
reconceiving2093455rec_onceiving
reconciling1645485rec__onciling
recondensing1653695rec_ondensing
reconferring1853725rec_onferring
reconning121410795rec_onn___ing
reconsoling1444485rec__onsoling
reconsulting1554215rec_onsulting
reconvening1746295rec_onve_ning
reconverting1876405rec_onverting
reconveying2044635rec_onve_ying
redialling1246205redia___lling
reenrolling1242705re__enrolling
reexpelling2142525re__expelling
refalling132010425re_fa___lling
refelling132211315re____felling
refuelling1474975re___fuelling
rehammering1953365re_hamme_ring
rehanging1437565re_ha_n__ging
rehardening1644145re_harde_ning
reheeling13218265re_h___eeling
relabeling1344195re_la_be_ling
remanning12229035re_mann___ing
remodelling1542785re__modelling
repelling122312755re____pelling
replanning1345315replann___ing
reselling102213835re____selling
resharpening1852345resharpe_ning
reshingling1642395resh_in_gling
respelling1347975re___spelling
retelling102112495re____telling
revelling132412555re____velling
scandalling1543445_sc_andalling
sentinelling13102365se_ntinelling
spancelling1643345__spancelling
teaselling1145335te__a_selling
teazelling2043805te__a_zelling
tunnelling1144385___tunnelling
unkennelling1751145_unkennelling
weaselling1454235we__a_selling

Search took 10 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.406440125.6
2DLD Change Limit1247901138.84314111.7
3Display Results1131130.0801412.5
 (SQL Overall)1786911139.32919154.4
 
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.