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

134 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
tolerate831232(None) 
tolerated1049121tolerated
tolerates9312121tolerates
dolerite9611772dolerite
moderate11710992moderate
oleate6318882_ole_ate
operate9615732_operate
overate10620962_overate
tolerable1147392tolerable
tolerance1145982tolerance
tolerant8411462tolerant
tolerative1346252tolerative
tolerator956752tolerator
tollgate946252tollgate
toluate7159342tol_uate
valerate11311472valerate
ablegate1147253ablegate
acerate92818913_acerate
acierate10311813acierate
aerate64830553__aerate
ameerate1039633ameerate
asperate10312373asperate
berate84729023__berate
bolete8519613bole__te
borate85026153bo__rate
celebrate1348093celebrate
cerate84829463__cerate
chlorate133112693chlorate
cocreate122611813cocreate
collate92919683col_late
colocate12313443colocate
conepate12712533conepate
cooperate13710143cooperate
copemate1439993copemate
corelate10516013corelate
coverage1438733coverage
cultrate10310873cultrate
deaerate9314173deaerate
delegate10410463delegate
derate74531233__derate
dolabrate1244493dolabrate
dolerites101410893dolerites
elevate101110373_elevate
emeerate10410103emeerate
exonerate16107733exonerate
federate12310883federate
filtrate1148223filtrate
folate93320393fol__ate
foliate10513533fol_iate
foredate12310913foredate
foveate1338363fove_ate
galeate83916793gale_ate
generate9312903generate
glomerate1245673glomerate
iterate71119113_iterate
itinerate9116253itinerate
lacerate102214713lacerate
legate72917453__legate
liberate101113383liberate
literate81216893literate
lyrate94112103__lyrate
macerate122314073macerate
maleate94117543male_ate
moderated1388143moderated
moderates12710753moderates
moderato1186263moderato
numerate101610393numerate
ocreate93711743_ocreate
oleates7417833_ole_ates
operated11512223_operated
operates10515413_operates
orate55133303_o__rate
outrate72323183_outrate
overage11514053_overage
overawe13511463_overawe
overhate14312793_overhate
overlate11716283_overlate
overrate11615693_overrate
paleate94120003pale_ate
pileate93815923pile_ate
poleaxe1656303pole_axe
polecat11313143polecat_
polecats1248833polecats
pollenate1157143pollenate
relegate9311243relegate
reoperate11410183reoperate
roseate7613453rose_ate
rostrate8313843rostrate
sclerae937933sclera_e
sclerite10410713sclerite
selenate81712533selenate
solate64526073sol__ate
soleplate1145283soleplate
soleret7321233soleret_
solerets839693solerets
solvate102710213sol_vate
sororate8411173sororate
stalemate1146643stalemate
stolonate944833stolonate
tablemate1344833tablemate
tartrate899693tartrate
telepath1345143telepath
teleran7510183telera_n
telerans859473telerans
temperate1348513temperate
terete6319333t__erete
ternate7415483t__ernate
thecate123210023t_hecate
tholeiite1243793tholeiite
titrate72215573t_itrate
toccate1138773to_ccate
toeplate1047613toeplate
togate74515683to__gate
toilette846683toile_tte
tolane64316583tol__ane
tolerably1445273tolerably
tolerances1245993tolerances
tolerantly1353653tolerantly
tolerating1148593tolerating
toleration1048963toleration
tolerators1046733tolerators
tollage82610163tol_lage
tollgates1046053tollgates
toluates8138903tol_uates
tonette7310373tone_tte
torquate1745003torquate
torte55431703to__r_te
totemite1046873totemite
ulcerate1039733ulcerate
underate9918603underate
valerates12310543valerates
venerate11312903venerate
volvate13317993vol_vate
yokemate1744313yokemate

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621347.53319402.9
3Display Results1341340.0462913.0
 (SQL Overall)1786911348.00222330.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.