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

109 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
summating143794(None) 
summiting1445791summiting
gemmating1576442gemmating
rummaging1543362rummaging
sublating12310982sublating
sulfating1338062sulfating
summation1347802summation
summations1456782summations
summative1646202summative
summering1458752summering
summing122912382summ__ing
summoning14115692summoning
animating12312503animating
automating1389303automating
bromating1439173bromating
bumming143410783bumm__ing
combating16310163combating
commuting16288443commuting
consummating1953663consummating
cremating14312193cremating
cumulating1546353cumulating
curating11314293cu_rating
dummying17263723dumm_ying
emulating1239873emulating
estimating1348883estimating
fumigating1744653fumigating
furcating1537783furcating
grummeting1642453grummeting
gumming133810193gumm__ing
humming153310673humm__ing
luxating1645613lu_xating
mating94832913___mating
mismating141211823mismating
moating104218153__moating
mumming114010023mumm__ing
mummying15263723mumm_ying
mutating112211753mu_tating
numerating1357233numerating
nutating92411953nu_tating
outdating11810863outdating
outeating10814493outeating
outrating10916403outrating
plummeting1742103plummeting
pulsating1236343pulsating
pummeling1643603pummeling
pupating1337683pu_pating
remating112322413_remating
ruinating1039593ruinating
rumbaing13185303rumba_ing
ruminating1348143ruminating
sambaing1337113samba_ing
satiating10311803satiating
sating74735453s___ating
scrummaging1951143scrummaging
scumming15256793scumm__ing
seating84130683s__eating
sedating103014113s_edating
sensating1039253sensating
seriating10916403seriating
serrating10513203serrating
simmering1467823simmering
simulating1347613simulating
sinuating1039683sinuating
situating1038883situating
skating123613853s__kating
slating83724653s__lating
slumming13278383slumm__ing
smarting113212453s_marting
smearing113511753s_mearing
smelting11339713s_melting
smiting103014443s__miting
smutting11278063s_mutting
solating9315593s_olating
solvating1336443solvating
stating83725163s__tating
striating10914193striating
stumming13347673stumm__ing
sublimating1675463sublimating
submarine1347843submarine
submitting1544973submitting
subwaying1843873subwaying
sufflating1744843sufflating
sugaring1039053su_garing
suiting83419003su__iting
sulphating1644323sulphating
summand1236263summa__nd
summaries13118183summaries
summarily1643833summarily
summarise13115733summarise
summarising1653563summarising
summarist13116763summarist
summarize22105653summarize
summarizing2544583summarizing
summate113611663summat__e
summated13298833summat_ed
summates122610493summat_es
summational1553683summational
summonsing1543093summonsing
sunbathing1642933sunbathing
supinating1357833supinating
surfacing1545643surfacing
surmising1247683surmising
surnaming1245143surnaming
surtaxing1784143surtaxing
sweating123213023s_weating
umlauting1243163_umlauting
unmaking1538133_unmaking
updating1236593_updating
uprating11311113_uprating

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.420425454.8
2DLD Change Limit1486411097.26620457.1
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.73223110.6
 
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.