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

203 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
primage1216914(None) 
primages13159271primages
primate111516281primate
fromage1336752fromage
grimace1255082grimace
image81411292__image
pipage1199142p_ipage
plumage1245502plumage
premade12311442premade
presage10312292presage
prima95019342prima__
primacy1635602primacy
primal104014622prima_l
primary1437702primary
primas104418102prima_s
primates121515932primates
prime96525602prim__e
primine113214822primine
primsie1137542primsie
private121513262private
reimage1037912reimage
rivage1038842_rivage
triage72812892tri_age
animate91617213animate
brewage1347183brewage
bridge103711883bri_dge
brigade1136493brigade
brokage1436673brokage
bromate11313553bromate
climate11312833climate
coinage10310553coinage
cremate113816183cremate
cribbage1542973cribbage
crime94822693crim__e
crimine112413473crimine
crimple13408693crimple
cringe93515483cri_nge
damage10410783_damage
drainage1045783drainage
drayage1234433drayage
driftage1342933driftage
fridge11379253fri_dge
frigate11311063frigate
fringe104013953fri_nge
fromages1437073fromages
fruitage1244343fruitage
grillage1055613grillage
grimaced1463313grimaced
grimacer1363963grimacer
grimaces1355383grimaces
grime85021323grim__e
heritage1246533heritage
homage121210603_homage
imaged1097763__imaged
imager9108123__imager
images91411463__images
imago8118693__imago
linage7713403_linage
mage75739133___mage
milage93414123_milage
mirage92313653_mirage
nonimage1144883nonimage
ohmage1295063_ohmage
package16128013package
page76036103p___age
palmate113215233palmate
passage1039803passage
pawnage1335873pawnage
peage84723573p__eage
peerage1089803peerage
pelage9515363p_elage
peonage1048723peonage
phage115113673p__hage
pikake11115803p_ikake
pilgrimage165923pilgrimage
pillage103412603pillage
pima85428663p_ima__
pimas94725103p_ima_s
pimple123512963p_imple
pipages1289423p_ipages
pipeage1236203pipeage
pirate82322883p_irate
plage84520403p__lage
plicae10410953plica_e
plicate11314513plicate
plumaged1443573plumaged
plumages1335653plumages
plumate1149803plumate
pomace123111913p_omace
pomade113611333p_omade
portage103013643portage
postage103214853postage
potage92715903p_otage
pottage103310603pottage
prase76128753pr__ase
prate75135983pr__ate
preaged11612333pr_eaged
prebade12310283prebade
prebake1539093prebake
predate10616893predate
preface14510923preface
prefade1339013prefade
pregame1239553pregame
prelate9519693prelate
preman104117453prema_n
premie103617993prem_ie
premise113818553premise
premune1138933premune
prename11412643prename
prepare111913623prepare
prepave14228873prepave
prerace11414123prerace
presaged1238813presaged
presager1138443presager
presages11312203presages
presale9416353presale
pretape113511623pretape
priapi1037923pri_api
price93725413pri__ce
prickle153611013prickle
pride84724743pri__de
prig75924873pri__g_
prigged12398933pri_gged
prigs85219703pri__gs
prim85132203prim___
primacies1548453primacies
primaries13410833primaries
primatal1247133primatal
primavera1642403primavera
primed115118913prim_ed
primely1457723primely
primer105118683prim_er
primero11368923primero
primers114215673primers
primes104225263prim_es
primi95017403prim__i
primines123013703primines
priming123417373priming
primings13338143primings
primly13439623prim_ly
primmed14388853primmed
primmer134310163primmer
primo95017913prim__o
primos104514423prim_os
primp115615923prim__p
primped14479153primped
primps124711823prim_ps
primrose1244503primrose
prims95425933prim__s
primula1145713primula
primus103712173prim_us
primuses1237083primuses
prince104114763pri_nce
priorate10411733priorate
prise74632613pri__se
prisere9310943prisere
pristane10310343pristane
prithee1239933prithee
privacy1744233privacy
privater13158533privater
privates131812373privates
prize164718943pri__ze
probate11414483probate
profane122111863profane
prolate9419793prolate
promine112819443promine
promise113415843promise
promote11313143promote
promulge1343043promulge
pronate9418873pronate
propane112716153propane
prophage1649433prophage
prorate9418733prorate
protege1059153protege
proximate2045773proximate
pupilage1343773pupilage
rage55742353_r__age
ramate83921693_ramate
rampage1237453_rampage
ravage1039303_ravage
reimaged1246173reimaged
reimages1138373reimages
remade94316983_remade
remake124016113_remake
remate84428683_remate
ridge75018683_ri_dge
rime65138893_rim__e
rimose8310593_rimose
rimple103814583_rimple
rivages1138873_rivages
rummage1234583rummage
scrimmage1642263scrimmage
silage72715303_silage
soilage8169353soilage
spinage10289653spinage
spoilage11195373spoilage
springe103913983spri_nge
triaged92810443tri_aged
triages82613793tri_ages
tribade1037293tribade
unitage838993unitage
urinate7315363urinate
visage1049083_visage

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272037.51617832.2
3Display Results2032030.0762671.1
 (SQL Overall)1786912037.99822342.0
 
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.