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

130 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
paginates12311137(None) 
paginate114012441paginate_
paginated13309461paginated
patinates113814701patinates
agitates9310882_agitates
agnates82813192_ag_nates
alginates10310122alginates
evaginates1475992evaginates
laminates112712902laminates
magnates11511612mag_nates
marginates13168752marginates
marinates112516392marinates
patinate103016312patinate_
patinated123911412patinated
vaginate123911082vaginate_
vaginated14328152vaginated
agates76121343_ag__ates
agemates111110033_agemates
agitate8312063_agitate_
agitated1038413_agitated
agminate1139243_agminate_
agnate73314883_ag_nate_
alginate9310693alginate_
alienates9310693_alienates
amirates101114803_amirates
animates101316423_animates
annates72415423_a_nnates
arginases1046393arginases
aviates10313083_avi_ates
badinages13124873badinages
cabinmates1643893cabinmates
califates14310113califates
carinate103320253carinate_
carinated123414273carinated
caseinates1247443caseinates
catenates11311813catenates
cavitates14168963cavitates
cogitates1247863cogitates
cognates11311583cog_nates
deaminates1349383deaminates
dominates12311743dominates
evaginate1376483evaginate_
evaginated1575133evaginated
fascinates1547153fascinates
geminates12310043geminates
invaginates1544843invaginates
iodinates1048203iodinates
kainites1238793ka_inites
kalifates1646133kalifates
labiates101011523labi_ates
laminate103014633laminate_
laminated122610283laminated
lancinates1247153lancinates
lapidates1247143lapidates
machinates1747323machinates
magnate10512703mag_nate_
manganates1345953manganates
marginate12179603marginate_
marginated14187343marginated
marinades12268983marinades
marinate103017783marinate_
marinated122513173marinated
navigates1345873navigates
nominates11311053nominates
ordinates1049003ordinates
originates1145963originates
paganises1239733paganises
paganizes2148673paganizes
pageants1136693pageant_s
paginal10269493pagina__l
paginating1447533paginating
pagination1348993pagination
paginations1447763paginations
pagings114411063pagin__gs
painches1588933pa_inches
painted104214633pa_in_ted
painter93814563pa_in_ter
painters103013033pa_in_ters
paints85921833pa_in_t_s
palates93624943pa__lates
palatinates1345013palatinates
palinodes1245903palinodes
palisades1245613palisades
palliates11311043palliates
palmitates1445453palmitates
palpates122613063pa_lpates
palpitates1445303palpitates
parietes10714553pari_etes
passivates1544963passivates
patinae95414403patina_e_
patinaed11407833patina_ed
patinas96318533patina__s
patines95225773patin__es
patinizes20710343patinizes
patriates11311373patriates
pawnages1435313pa_wnages
penates93321603p__enates
pepsinates1446373pepsinates
phenates13611583p_henates
phonates13410643p_honates
pinatas93711503p__inatas
pinites9319533p__inites
pirates93020333p__irates
pointes93216753p_oin_tes
pollinates1247303pollinates
primates121515933p_rimates
privates131812383p_rivates
pronates10418373p_ronates
rabbinates1444523rabbinates
radiates92415303radi_ates
radicates12412073radicates
raffinates1644363raffinates
resinates9314773resinates
ruinates8311883_ruinates
ruminates11410193ruminates
salivates1239293salivates
sanitates9611733sanitates
satiates8314633sati_ates
stagnates1046733stag_nates
supinates1139553supinates
tannates81911953ta_nnates
urinates8314133_urinates
vaccinates1746563vaccinates
vaginae11377683vagina_e_
vaginas11298813vagina__s
vaginitis1344273vaginitis
vaginoses1344143vaginoses
validates1338243validates
variates111214993vari_ates
wagonages1443303wagonages

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411307.53019739.8
3Display Results1301300.0632063.5
 (SQL Overall)1786911308.02922255.7
 
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.