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

93 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
attaching154543(None) 
attacking1635321attacking
attaining1047222attaining
attracting1346562attracting
detaching1637262detaching
reattaching1743122reattaching
teaching143612602_teaching
aahing1019015763a__a_hing
abashing1466623a_bashing
aching126521973___aching
anticking1649243anticking
anticling12310693anticling
arching136216693a__rching
articling1247713articling
attach11118393attach___
attache12106693attach__e
attached14165703attach_ed
attacher13125713attach_er
attachers14134883attachers
attaches13137723attach_es
attachment1754143attachment
attain6311753atta__in_
attains7310983atta__ins
attaint7313473atta__int
attainting1144783attainting
attending11136373attending
attesting1036383attesting
atticizing2246323atticizing
attiring939483att_iring
attorning1045503attorning
attriting1048683attriting
attuning935903att_uning
avouching1843273avouching
baching156017753__baching
batching163712093bat_ching
beaching164114143_beaching
bitching163610623bit_ching
bleaching17287093bleaching
botching16359703bot_ching
breaching17269403breaching
broaching17287663broaching
caching156317503__caching
catching163712773cat_ching
catfacing1744553catfac_ing
coaching164011963_coaching
ditching15349943dit_ching
etching134511843_et_ching
fetching17298413fet_ching
hatching173312213hat_ching
hitching173310523hit_ching
hotching17309313hot_ching
hutching17318643hut_ching
itching134011683_it_ching
latching143712023lat_ching
latticing1246063lattic_ing
leaching143012833_leaching
letching143810263let_ching
matching163512393mat_ching
notching14288583not_ching
outacting1239213outacting
patching163212753pat_ching
peaching163613643_peaching
pitching163411113pit_ching
pleaching17257083pleaching
poaching163510833_poaching
preaching172811163preaching
reaching143317203_reaching
reattacking1843303reattacking
retacking1658973retacking
retching143412173ret_ching
reteaching1636023reteaching
roaching143210433_roaching
snatching1536363snatching
stacking154215083_stacking
stanching1538083stanching
starching1538593starching
stashing123511583_stashing
stitching1547103stitching
stomaching1844313stomaching
tacking144421483__tacking
teachings15296553_teachings
thacking183110043_thacking
thatching1835143_thatching
torching142510083_torching
touching143211343_touching
trachling1537823_trachling
tracing103720153_trac_ing
tracking153715463_tracking
trashing122613223_trashing
untacking1636643untacking
unteaching1645493unteaching
watching173011173wat_ching
witching173410633wit_ching

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.576310227.4
2DLD Change Limit148641936.72022119.2
3Display Results93930.0462021.7
 (SQL Overall)178691937.34224338.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.