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

159 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
paginate11401244(None) 
paginated13309461paginated
paginates123111361paginates
patinate103016311patinate
vaginate123911081vaginate
agitate8312062_agitate
agminate1139242_agminate
agnate73314882_ag_nate
alginate9310692alginate
carinate103320242carinate
evaginate1376482evaginate
laminate103014632laminate
magnate10512702mag_nate
marginate12179602marginate
marinate103017782marinate
paginal10269492pagina_l
patinae95414402patina_e
patinated123911412patinated
patinates113814692patinates
vaginae11377682vagina_e
vaginated14328152vaginated
adnate72913483_a_dnate
agate66525153_ag__ate
agemate101210583_agemate
agitated1038413_agitated
agitates9310883_agitates
agitato856573_agitato
agnates82813193_ag_nates
alginates10310123alginates
alienate8311553_alienate
amirate91115953_amirate
animate91617213_animate
arginase946433arginase
aviate9315203_avi_ate
badinage1294923badinage
binate8419773__binate
cabinmate1544093cabinmate
califate13310483califate
capitate121712183capitate
carinae94318583carina_e
carinated123414263carinated
caseinate1148243caseinate
catenate10312833catenate
catkinate1545823catkinate
cavitate13159833cavitate
cogitate1148553cogitate
cognate10312203cog_nate
deaminate12410173deaminate
digitate1098683digitate
dominate11312853dominate
echinate1359403echinate
emarginate1385453emarginate
evaginated1575133evaginated
evaginates1475993evaginates
fascinate1447763fascinate
geminate11411813geminate
invaginate1445053invaginate
iodinate949343iodinate
kainite1149543ka_inite
kalifate1556493kalifate
labiate91313573labi_ate
laciniate1156843laciniate
lacunate10128963lacunate
laminae93512973lamina_e
laminated122610283laminated
laminates112712903laminates
lanate6421263la__nate
lancinate1147803lancinate
lapidate1157903lapidate
machinate1647953machinate
magnates11511613mag_nates
manganate1246403manganate
marginated14187343marginated
marginates13168743marginates
marinade11259383marinade
marinated122513173marinated
marinates112516383marinates
navigate1246073navigate
nominate10312473nominate
ordinate9310253ordinate
originate1047023originate
paganise1139663paganise
paganize2048633paganize
pageant10312783pageant_
pageants1136693pageants
paginating1447523paginating
pagination1348993pagination
paging104020403pagin__g
pagings114411063pagin_gs
paint75443693pa_in_t_
painted104214633pa_in_ted
painter93814563pa_in_ter
paints85921833pa_in_ts
painty114714753pa_in_ty
palate84226783pa__late
palatinate1245593palatinate
paleate94120003pa_leate
palinode1145713palinode
palisade1145833palisade
palliate10311893palliate
palmate113215233pa_lmate
palmitate1346413palmitate
palpate113213923pa_lpate
palpitate1365973palpitate
papillate13127573papillate
parlante1039693parlante
passionate1245973passionate
passivate1445683passivate
patina86022193patina__
patinaed11407833patinaed
patinas96318523patina_s
patine85328123patin__e
patinize19610773patinize
patriate10311933patriate
pawnage1335873pa_wnage
pectinate1349553pectinate
pennate93314033p_ennate
pepsinate1346633pepsinate
phenate12412203p_henate
phonate12411813p_honate
pinata83817223p__inata
pinite8321243p__inite
pinnate93613743p_innate
pirate82322883p__irate
planate9314573p_lanate
plicate11314513p_licate
pointe84619313p_oin_te
pollinate1147713pollinate
primate111516283p_rimate
private121513263p_rivate
pronate9418873p_ronate
pulvinate1445193pulvinate
quinate16511573_quinate
rabbinate1345143rabbinate
radiate83416313radi_ate
radicate11412873radicate
raffinate1545023raffinate
reginae84713453regina_e
resinate8316773resinate
ruinate7312833_ruinate
ruminate10511473ruminate
sagittate1043603sagittate
salivate11310013salivate
sanitate8612043sanitate
satiate7315403sati_ate
spinate93114813_spinate
stagnate947243stag_nate
staminate1187983staminate
supinate10310313supinate
tannate71813523ta_nnate
uncinate10312393uncinate
urinate7315363_urinate
vaccinate1646833vaccinate
vagina102710933vagina__
vaginal11288403vagina_l
vaginas11298813vagina_s
validate1239003validate
variate101316433vari_ate
wagonage1343293wagonage

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621597.36019859.0
3Display Results1591590.0632523.8
 (SQL Overall)1786911597.82622833.0
 
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.