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

68 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
tolerating114859(None) 
moderating1448802moderating
operating12313722_operating
toleration1048962toleration
tolerations1158132tolerations
tolerative1346252tolerative
acierating1348313acierating
aerating92821003__aerating
alerting91312383_aler_ting
asperating1349563asperating
berating113220763__berating
bleating113514503_ble_ating
borating113414503bo__rating
celebrating1646113celebrating
cleating113518133_cle_ating
cocreating15310293cocreating
coleading1338523cole_ading
collating12312763col_lating
colocating1548623colocating
cooperating1648423cooperating
corelating13511583corelating
deaerating12311563deaerating
delegating1337673delegating
derating103222283__derating
elevating1338203_elevating
exonerating1945553exonerating
federating1548853federating
filtrating1445973filtrating
foliating1339253fol_iating
foredating1577123foredating
generating12310383generating
iterating10314253_iterating
itinerating1245233itinerating
lacerating1349443lacerating
legating102313113__legating
liberating1349253liberating
macerating1549533macerating
molesting1237753mole_sting
numerating1357233numerating
orating83520323_o__rating
outrating10916403_outrating
overacting16310913_overacting
overawing16710293_overawing
overeating141016533_overeating
overhating17910953_overhating
overrating14814203_overrating
pleating112916053_ple_ating
poleaxing1944873pole_axing
pollenating1444553pollenating
relegating1239483relegating
reoperating1449023reoperating
solating9315593sol__ating
solvating1336443sol_vating
stalemating1444683stalemating
telecasting1443793telecasting
threating131010053thre_ating
titrating10310113t_itrating
toileting1036263toile__ting
tolerant8411463tolera__nt
tolerate8312323tolerat__e
tolerated1049123tolerat_ed
tolerates9312123tolerat_es
tolerator956753tolerat_or
tolerators1046733tolerators
towering122610873tower__ing
treating92519613t_re_ating
ulcerating1346983ulcerating
venerating14410053venerating

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 Filter1786911406030.440406115.9
2DLD Change Limit140603686.43621846.3
3Display Results68680.0302266.7
 (SQL Overall)178691686.90625874.7
 
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.