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

112 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
paginated1330946(None) 
paginate114012441paginate_
paginates123111361paginates
patinated123911411patinated
vaginated14328151vaginated
agitated1038412_agitated
carinated123414262carinated
evaginated1575132evaginated
laminated122610282laminated
marginated14187342marginated
marinated122513172marinated
painted104214632pa_in_ted
patinaed11407832patina_ed
patinate103016312patinate_
patinates113814692patinates
vaginate123911082vaginate_
agented939423_agen_ted
agisted938203_agi_sted
agitate8312063_agitate_
agitates9310883_agitates
agminate1139243_agminate_
agnate73314883_ag_nate_
agnates82813193_ag_nates
alginate9310693alginate_
alginates10310123alginates
alienated1047743_alienated
animated111612373_animated
aviated11310263_avi_ated
badinaged14113193badinaged
capitated14159043capitated
carinate103320243carinate_
catenated1238913catenated
cavitated15177353cavitated
cogitated1346323cogitated
deaminated1448013deaminated
digitated1286963digitated
dominated1339883dominated
echinated1546483echinated
evaginate1376483evaginate_
evaginates1475993evaginates
fainted114211723fa_in_ted
fascinated1645873fascinated
geminated1338553geminated
invaginated1654403invaginated
iodinated1146943iodinated
labiated11109303labi_ated
laminate103014633laminate_
laminates112712903laminates
lanated8313203la__nated
lancinated1345573lancinated
lapidated1345673lapidated
lariated91212063lari_ated
machinated1845663machinated
magnate10512703mag_nate_
magnates11511613mag_nates
marginate12179603marginate_
marginates13168743marginates
marinaded13276533marinaded
marinate103017783marinate_
marinates112516383marinates
navigated1445483navigated
nominated1239283nominated
originated1244813originated
paganised1346623paganised
paganized2247163paganized
paginal10269493pagina__l
paginating1447523paginating
pagination1348993pagination
pained95622853pa_in__ed
painter93814563pa_in_ter
palisaded1343563palisaded
palliated1238493palliated
palmated132511003pa_lmated
palpated13249763pa_lpated
palpitated1544233palpitated
panted95024823pa__n_ted
parented11912213paren_ted
passivated1644143passivated
patented1188893paten_ted
patinae95414403patina_e_
patined105114783patin__ed
patinized2178823patinized
patriated1238533patriated
pennated11299543p_ennated
pepsinated1545233pepsinated
phonated1447893p_honated
pinnated11338553p_innated
pirated102515613p__irated
pixilated1944543pixilated
plicated13310643p_licated
pointed103813983p_oin_ted
pollinated1345823pollinated
printed104016373p_rin_ted
pronated11414053p_ronated
radiated102512593radi_ated
radicated13410123radicated
resinated10413283resinated
ruinated939523_ruinated
ruminated1258663ruminated
sainted84114243sa_in_ted
salivated1337473salivated
sanitated1068993sanitated
saponated1245733saponated
satiated9311603sati_ated
stagnated1145143stag_nated
supinated1237883supinated
tainted83512423ta_in_ted
urinated9311613_urinated
vaccinated1855443vaccinated
vaginae11377683vagina_e_
validated1446493validated
variated121211393vari_ated

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.436409841.7
2DLD Change Limit1486411126.73322076.5
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.21524766.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.