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

61 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
craunching184331(None) 
cranching17278731cra_nching
crunching17297001cr_unching
branching17289262bra_nching
brunching17316482br_unching
crouching1746382crou_ching
crutching17216072cr_utching
launching1544782_launching
ranching141712042_ra_nching
scrunching18163472scr_unching
staunching1643212staunching
blanching17297093bla_nching
bunching163410703__bunching
caching156317503c_a__ching
catching163712773c_a_tching
chancing162810283cha_nc_ing
chaunting1555413chaun_ting
churching2055083c_hurching
cinching163310223c__inching
clenching17266303c_lenching
clinching17276123c_linching
clutching17154823c_lutching
coaching164011963coa__ching
couching163213263c_ou_ching
cracking174013903cra__cking
craning103620303cra_n__ing
cranking154613073cra_n_king
crankling16147293cra_nkling
crashing143512633cra__shing
craunch1464443craunch___
craunched1764023craunch_ed
craunches1655723craunch_es
crunchier1644683cr_unchier
crunchily1943193cr_unchily
crushing143010053cr_u_shing
drenching16256033dr_enching
frenching18267753fr_enching
frouncing1534763frounc_ing
glunching16174083_glunching
grouching1644943grou_ching
grutching16224373gr_utching
hunching17309113__hunching
jauncing18314783_jaunc_ing
lunching143110003__lunching
munching16299973__munching
prancing132612163pra_nc_ing
prelaunching2051503prelaunching
prepunching2142563prepunching
punching163310123__punching
raunchier1443713_raunchier
raunchily1742813_raunchily
relaunching1742243relaunching
ruching133612933_r_u_ching
scraiching1843793scra_iching
scratching1844533scra_tching
stanching1538083sta_nching
trancing112812023tra_nc_ing
trauchling1643473trau_chling
trenching15227653tr_enching
trouncing1235153trounc_ing
wrenching18276273wr_enching

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 Filter1786911406030.420425454.8
2DLD Change Limit140603616.75020830.1
3Display Results61610.0331848.5
 (SQL Overall)178691617.20324807.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.