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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
reacting11331789(None) 
preacting142412531preacting
reaching143317201reaching
redacting13612301redacting
abreacting1544532abreacting
acting95920982__acting
beaching164114142beaching
beating104326872bea_ting
breaching17269402breaching
breasting1239582breasting
coacting133412702coacting
creating113921952crea_ting
easting84924302_easting
eating75134402_ea_ting
enacting11311362enacting
erecting112415062erecting
eructing112110172eructing
exacting1838522exacting
feasting122011322feasting
hearting12513122hearting
heating114024322hea_ting
leaching143012832leaching
peaching163613642peaching
peacing124117072peac_ing
preaching172811162preaching
racing95030532r_ac_ing
racking144323662r_acking
rafting113815752r_afting
ranting84025412r_anting
rating74938702r_a_ting
ratting83822362r_atting
reactant10311432reactant
reaction10612602reaction
reactions11711712reactions
reactive13310472reactive
readding11411362readding
reading93327212rea_ding
readying13410222readying
reaming103924012rea_ming
reaping103621212rea_ping
rearing83128782rea_ring
rearming111413612rearming
reaving113820532rea_ving
rebaiting12311642rebaiting
rebating112418342rebating
recaning111416692recaning
recanting122414822recanting
recasting122414232recasting
reciting113118072reciting
recking144319922re_cking
redating102620172redating
reenacting1357352reenacting
reesting93118272reesting
refacing142512812refac_ing
refecting152413352refecting
refracting1638732refracting
refuting121911902refuting
rejecting192211152rejecting
relacing112516042relac_ing
relating92725442relating
relucting1239772relucting
remating112322422remating
renting84026852re_nting
repacking1838282repacking
repasting122312842repasting
reputing112412602reputing
reracking1639312reracking
rescuing1139622rescuing
resecting122816482resecting
resiting93521122resiting
resting85031182re_sting
retacking1658972retacking
retasting102513412retasting
retching143412172retching
retracting13311932retracting
retting83425882re_tting
revoting12312032revoting
roaching143210432roaching
roasting93012702roasting
seating84130682sea_ting
teaching143612602teaching
treating92519612trea_ting
yeasting12188922yeasting

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 Filter1786911210590.393454684.5
2DLD Change Limit121059833.87331257.2
3Display Results83830.0461804.3
 (SQL Overall)178691834.31241440.4
 
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.