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

142 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
breeching1723647(None) 
breaching17269401breaching
breechings18273721breechings
beaching164114142b_eaching
belching16349152b_elching
benching163411342b_enching
beseeching1843362beseeching
bleaching17287092bleaching
blenching17276502blenching
branching17289262branching
breathing15218372breathing
breeding123411842bree_ding
breezing20368132bree_zing
broaching17287662broaching
brunching17316482brunching
creeshing1536242creeshing
drenching16256032drenching
fleeching18305012fleeching
frenching18267752frenching
leeching14318372_leeching
preaching172811162preaching
reaching143317202_reaching
reechoing1545292_reechoing
retching143412172_retching
screeching1843642screeching
trenching15227652trenching
unbreeching1942162unbreeching
wrenching18276272wrenching
abreacting1544533abreacting
arching136216693ar__ching
baching156017753b__aching
barbecuing1752323barbecuing
batching163712093b_atching
becking164416073b__ecking
bedecking1934283bedecking
bedrenching2052273bedrenching
beechen14367703b_eechen_
beechier1535633b_eechier
beefing133911473b_ee_fing
beeping124013913b_ee_ping
beeswing14255763b_eeswing
beetling1139283b_eetling
bereaving1537573bereaving
berthing14209603b_erthing
birching16328463b_irching
bisecting1436973bisecting
bitching163610623b_itching
blanching17297093blanching
bleeding12359053blee_ding
bleeping13377933blee_ping
blotching1734963blotching
botching16359703b_otching
bracing123817613br_ac_ing
breading123515463br_eading
breaking153914253br_eaking
breaming133612513br_eaming
breasting1239583breasting
breathings16234313breathings
brechan1437223br_echan_
brechans1547413br_echans
breech13348263breech___
breeched16337383breech_ed
breeches15258673breech_es
breedings13375763bree_dings
breveting1536263breveting
brevetting1644333brevetting
brewing133411153br_e_wing
bricking173911403br_icking
briefing1436943brie_fing
brushing14359963br_ushing
bunching163410703b_unching
clenching17266303clenching
cranching17278733cranching
creeling113513363cree_ling
creeping133310103cree_ping
crouching1746383crouching
crunching17297003crunching
crutching17216073crutching
dreeing94311183dree__ing
eching126315563___eching
erecting112415063er_ecting
etching134511843__etching
fetching17298413_fetching
fleecing14347573fleec_ing
flenching18296703flenching
fletching18256143fletching
freeing113713913free__ing
freezing21308323free_zing
frescoing1544683frescoing
freshing152611023fr_eshing
greeing93613783gree__ing
greening103112533gree_ning
greenling1136753greenling
greenwing1434693greenwing
greeting103112353gree_ting
grouching1644943grouching
grutching16224373grutching
kvetching2242903kvetching
leaching143012833_leaching
leching134613653__leching
letching143810263_letching
peaching163613643_peaching
peching154513903__peching
perching163711633_perching
pleaching17257083pleaching
preacting142412533preacting
preceding15129363preceding
preeing103817673pree__ing
preening113115843pree_ning
prelecting15310163prelecting
quenching2443923quenching
ranching141712043_ranching
reacting113317893_reacting
receding122713763_receding
recking144319923_r_ecking
reechier1336673_reechier
reeding94124133_ree_ding
reedling102414273_reedling
reefing114016863_ree_fing
reeking123318643_ree_king
reeling83126863_ree_ling
reesting93118273_reesting
reeving113717663_ree_ving
refecting152413353_refecting
rejecting192211153_rejecting
rescuing1139623_rescuing
resecting122816483_resecting
reteaching1636023_reteaching
roaching143210433_roaching
ruching133612933_r_uching
seething1239023_seething
sketching1935083sketching
skreeghing1941483skreeghing
stretching1645813stretching
teaching143612603_teaching
teething1237163_teething
treeing83414303tree__ing
upreaching1844113upreaching
welching17287363_welching
wenching17328863_wenching
wreathing16266313wreathing
wrecking18328153wr_ecking

Search took 7 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 Limit1486411426.40623203.4
3Display Results1421420.0632254.0
 (SQL Overall)1786911426.89225927.3
 
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.