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

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

107 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
scrunches163540(None) 
crunches153711351_crunches
scrunched1744031scrunched
scrunchies1744351scrunchies
brunches153710452_brunches
cranches153114542_cranches
craunches1655722_craunches
crunched16328162_crunched
cruncher15338072_cruncher
crunchers16316242_crunchers
crutches15359592_crutches
scratches1647322scratches
screeches1695652screeches
scrooches1645702scrooches
scrunch1444032scrunch__
scrunchie1643032scrunchie
scrunchy1852382scrunch_y
sculches15176272sc_ulches
scutches15168882sc_utches
staunches1444602staunches
branches153613803_branches
brunched16317853_brunched
bruncher15347783_bruncher
brunchers16296253_brunchers
bunches144116033__bunches
caruncles1345003caruncles
chinches18369363_chinches
churches1846433_churches
cinches144215773_c_inches
clenches152910953_clenches
clinches153910363_clinches
clutches15307923_clutches
conches144019813_c_onches
couches144020473_cou_ches
cranched163210413_cranched
cratches153012543_cratches
craunched1764023_craunched
creches14313093_cr_eches
crotches153411303_crotches
crouches153711293_crouches
cruces105117543_cru_c_es
crunch13349503_crunch__
crunchier1644683_crunchier
crunchiest1764793_crunchiest
crunchy17324763_crunch_y
crunodes1144973_crunodes
crushes124215133_cru_shes
crutched16307463_crutched
culches143710743_c_ulches
curches143512743_c_urches
cutches143216463_c_utches
drenches14309803_drenches
dunches133312583__dunches
frenches163311633_frenches
furuncles1442493furuncles
glunches1436263_glunches
grinches1436953_grinches
grutches14285853_grutches
haunches1656963_haunches
hunches153913463__hunches
launches1387903_launches
lunches124115443__lunches
munches144215793__munches
paunches1568173_paunches
punches144816133__punches
ranches123620113__ranches
raunches1368053_raunches
ruches114819583__ru_ches
sciences1238773scienc_es
sconces113811453sc_onc_es
scooches15188413sc_ooches
scootches1635003scootches
scorches15189143sc_orches
scotches15179473sc_otches
scraiched1744203scraiched
scraichs1543993scraich_s
scratched1735393scratched
scratcher1635443scratcher
scratchers1744293scratchers
screeched17114343screeched
screecher16144483screecher
screechers17143683screechers
scrooched1763843scrooched
scrootches1743323scrootches
scrounges1243923scroun_ges
scrunching18163473scrunching
scruples1237433scru_ples
scultches1664293scultches
scuncheon1642283sc_uncheon
scuncheons1752073sc_uncheons
scutched16186893sc_utched
scutcher15176963sc_utcher
scutchers16175643sc_utchers
slouches13208073slou_ches
smutches15177273s_mutches
soroches1338803sor_oches
spruces113810503spru_c_es
squinches2344253squinches
stanches132312793s_tanches
staunched1553473staunched
stauncher1443513stauncher
staunchest1543123staunchest
stenches132110293s_tenches
stretches1438293stretches
tranches132915513_tranches
trenches133512603_trenches
wrenches163210233_wrenches

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411077.01621186.0
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.48223882.8
 
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.