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

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

102 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
beaches14412065(None) 
baches135426941b_aches
beached154516551beached
beeches143413881beeches
belches143514341belches
benches143918601benches
bleaches153410671bleaches
braches144621221braches
breaches153714111breaches
leaches123319341leaches
peaches144120051peaches
reaches123423201reaches
teaches122718351teaches
aches106132292__aches
apaches143411832apaches
bached145519892b_ached
bashes115631392b_ashes
batches144019612batches
bathes116524832b_athes
beach124623892beach__
beachier1538802beachier
beachiest1638442beachiest
beachy164011252beach_y
beacons11410732beacons
beadles103414732beadles
beagles103212122beagles
beanies93821092beanies
beechen14367702beechen
belched154011842belched
belcher143511492belcher
belchers153510022belchers
benched154713942benched
bencher144113482bencher
benchers153611012benchers
berdaches1745052berdaches
birches143412322birches
bitches144117062bitches
blanches153311602blanches
bleached16378562bleached
bleacher15358882bleacher
bleachers16297922bleachers
blenches153310762blenches
boches134618522b_oches
botches143716022botches
braces108427772brac_es
brachet144020312brachet
brachets154311982brachets
brachs134415752brach_s
branches153613802branches
brashes124518462brashes
breached163411642breached
breacher153011502breacher
breachers16369852breachers
breathes134212902breathes
breeches15258672breeches
broaches153211622broaches
bunches144116032bunches
butches144315362butches
caches137926912_caches
coaches144018692coaches
deashes113313902deashes
detaches1439652detaches
eches106322162_e_ches
etches114217762_etches
fetches153413892fetches
kenches163912272kenches
ketches164012192ketches
laches116528342_laches
leached133715042leached
leacher124014842leacher
leachers133712812leachers
leashes103514402leashes
leches115421312le_ches
leeches123911932leeches
letches124015482letches
loaches123613982loaches
maches134827232_maches
merches144013762merches
naches114622412_naches
oraches124216472oraches
peaces106324082peac_es
peached154315882peached
peacher144216072peacher
peachers153213842peachers
perches143717952perches
pleaches153210432pleaches
poaches144416942poaches
preaches153214892preaches
reached134619082reached
reacher123718292reacher
reachers133515722reachers
retches123318512retches
roaches123616212roaches
searches132112902searches
seiches12513812seiches
taches114224172_taches
teacher123714832teacher
teachers133212392teachers
tenches123515522tenches
vetches153411262vetches
welches153710312welches
wenches152914132wenches

Search took 5 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 Filter1786911076710.1431249587.4
2DLD Change Limit1076711023.87327800.4
3Display Results1021020.0333090.9
 (SQL Overall)1786911024.04944132.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.