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

129 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
craunches165572(None) 
cranches153114541cra_nches
craunched1764021craunched
crunches153711351cr_unches
raunches1368051_raunches
branches153613802bra_nches
brunches153710452br_unches
caruncles1345002caruncles
cranched163210412cra_nched
cratches153012542cra_tches
craunch1464442craunch__
crouches153711292crou_ches
crunched16328162cr_unched
cruncher15338072cr_uncher
crunchers16316242cr_unchers
crutches15359592cr_utches
haunches1656962_haunches
launches1387902_launches
paunches1568172_paunches
ranches123620112_ra_nches
scrunches1635402scr_unches
staunches1444602staunches
tranches132915512tra_nches
blanches153311603bla_nches
braches144621223bra__ches
branched163210453bra_nched
braunites1146723braunites
brunched16317853br_unched
bruncher15347783br_uncher
brunchers16296253br_unchers
bunches144116033__bunches
caches137926913c_a__ches
caleches15269943c_aleches
caliches153812273c_aliches
canchas143212403c_a_nchas
capuches1735513c_apuches
carbuncles1643453carbuncles
caroaches1637793caroaches
caroches15710693c_aroches
carroches1665893carroches
caruncle1244713caruncle_
catches144320773c_a_tches
chances145218093cha_nc_es
chancres15429363cha_ncres
chinches18369363c_hinches
churches1846433c_hurches
cinches144215773c__inches
clenches152910953c_lenches
clinches153910363c_linches
clutches15307923c_lutches
coaches144018693coa__ches
conches144019813c__onches
couches144020473c_ou_ches
cranch133613533cra_nch__
cranes84330753cra_n__es
crankles143510153cra_nkles
crannies10313013cra_nnies
crannoges1244243crannoges
crashes124618403cra__shes
craunching1843313craunching
creches14313093cr__eches
crotches153411303cr_otches
crouched16359143crou_ched
cruces105117543cr_u_c_es
crunch13349503cr_unch__
crunchier1644683cr_unchier
crunchiest1764793cr_unchiest
crunchy17324763cr_unch_y
crunodes1144973cr_unodes
crushes124215133cr_u_shes
crutched16307463cr_utched
culches143710743c__ulches
curches143512743c__urches
cutches143216463c__utches
drenches14309803dr_enches
dunches133312583__dunches
frenches163311633fr_enches
frounces1336183frounc_es
glunches1436263_glunches
grinches1436953gr_inches
grouches14328213grou_ches
grutches14285853gr_utches
haunched1744813_haunched
hunches153913463__hunches
jaunces16307423_jaunc_es
launces9329003_launc_es
launched1475403_launched
launcher1365563_launcher
launchers1454333_launchers
lunches124115443__lunches
manches143818623_ma_nches
munches144215793__munches
nautches1336083_nautches
oraches124216473ora__ches
painches1588913_painches
paunched1645523_paunched
planches153111863pla_nches
prances113618773pra_nc_es
prelaunches1852233prelaunches
prepunches1954013prepunches
punches144816133__punches
rances84625443_ra_nc_es
ranched133113603_ra_nched
rancher123013633_ra_ncher
ranchers133311793_ra_nchers
ranchos123911393_ra_nchos
ratches123620463_ra_tches
raunch11358433_raunch__
raunchier1443713_raunchier
raunchiest1543933_raunchiest
raunchy15284313_raunch_y
relaunches1543443relaunches
rouches124217893_rou_ches
ruches114819583_r_u_ches
scratches1647323scra_tches
scrunched1744033scr_unched
scrunchies1744353scr_unchies
stanches132312793sta_nches
staunched1553473staunched
stauncher1443513stauncher
staunchest1543123staunchest
trances93919643tra_nc_es
tranche123312223tra_nche_
trauchles1445493trau_chles
trenches133512603tr_enches
trounces1037063trounc_es
truancies1146883truancies
usaunces1073373usaunc_es
wrenches163210233wr_enches

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.423422437.4
2DLD Change Limit1486411297.14020818.1
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.60923484.2
 
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.