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

100 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
tolerated104912(None) 
tolerate8312321tolerate_
tolerates9312121tolerates
moderated1388142moderated
operated11512222_operated
tolerator956752tolerator
acerated113113983_acerated
acierated1238283acierated
aerated85322373__aerated
alerted82512223_aler_ted
asperated1239313asperated
berated104422133__berated
bleated104015973_ble_ated
borated104116363bo__rated
celebrated1556223celebrated
cerated103922473__cerated
cleated103417843_cle_ated
cocreated142710093cocreated
collated113615063col_lated
colocated1439613colocated
cooperated1567333cooperated
corelated12411823corelated
cultrated1248223cultrated
deaerated11311113deaerated
delegated1238373delegated
derated93623503__derated
dolerite9611773dolerite_
dolerites101410893dolerites
elevated12118293_elevated
exonerated18106003exonerated
federated1438423federated
filtrated1345963filtrated
floreated1346573floreated
foliated1249913fol_iated
foredated1447683foredated
foveated1536293fove_ated
galeated104111583gale_ated
generated11310203generated
iterated91213823_iterated
itinerated11124933itinerated
lacerated122210683lacerated
legated92513983__legated
liberated1299473liberated
lyrated11388473__lyrated
macerated142010523macerated
moderate11710993moderate_
moderates12710753moderates
molested11178243mole_sted
nonrated9310843no_nrated
numerated12177873numerated
oersted839553_o_ersted
oleate6318883_ole_ate_
oleates7417833_ole_ates
operate9615733_operate_
operates10515413_operates
orated74221503_o__rated
outrated92219313_outrated
overacted1539633_overacted
overaged13511673_overaged
overate10620963_overate_
overawed1579973_overawed
overhated16610443_overhated
overrated13313083_overrated
pileated112711133pile_ated
pleated103816633_ple_ated
poleaxed1854823pole_axed
pollenated1345013pollenated
relegated1139763relegated
reoperated1348153reoperated
solated83618023sol__ated
solvated12237443sol_vated
stalemated1344323stalemated
talented938423tale_nted
tartrated1096643tartrated
teated74924023t__e_ated
telecasted1343943telecasted
threated1259203thre_ated
titrated92611683t_itrated
togated94410663to__gated
toileted936993toile__ted
tolerable1147393tolerable
tolerably1445273tolerably
tolerance1145983tolerance
tolerances1245993tolerances
tolerant8411463tolera_nt
tolerantly1353653tolerantly
tolerating1148593tolerating
toleration1048963toleration
tolerative1346253tolerative
tolerators1046733tolerators
tollgate946253tollgate_
tollgates1046053tollgates
toluate7159343tol_uate_
toluates8138903tol_uates
towered112911403tower__ed
treated83618703t_re_ated
ulcerated1247743ulcerated
valerate11311473valerate_
valerates12310543valerates
venerated1339953venerated

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.423422437.4
2DLD Change Limit1486411007.48619855.9
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.95522462.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.