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

111 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
primeness133865(None) 
primness1276761prim_ness
crimeless1335062crimeless
griminess1236702griminess
grimness1175992grim_ness
priceless1336882priceless
primenesses1548992primenesses
primines123013702primine_s
proneness11310442proneness
rifeness1138582_rifeness
riminess10510092_riminess
ripeness1039362_ripeness
trimness1067562trim_ness
triteness9310362triteness
agileness1046493agileness
alikeness1336333alikeness
aliveness1238223aliveness
aridness939223ari_dness
braveness14237763braveness
briefness1444113briefness
brimless1235273brim_less
brineless1136243brineless
brininess1138203brininess
briskness1544763briskness
crispness1345303crispness
crudeness1245753crudeness
dimness1038843_dim_ness
direness9311303_direness
drivenness1443463drivenness
fineness11310643_fineness
firmness1334743firm_ness
frameless1435533frameless
freeness11710443fr_eeness
gameness112810693_gameness
graveness13288383graveness
irateness9310493irateness
lameness102612673_lameness
likeness12229863_likeness
limeless10249663_limeless
liminess10510643_liminess
limpness1246703_limpness
liteness82213213_liteness
liveness112411393_liveness
naiveness1277493naiveness
niceness1039843_niceness
paleness10312983p_aleness
perimeters1448603perimeters
petiteness1248493petiteness
pileless1088623p_ileless
pimentos1246233p_imentos
pinenes93416673p_inene_s
pinkness1436513p_inkness
pipeless12107663p_ipeless
pipiness1238003p_ipiness
pixiness1736093p_ixiness
planeness1138153planeness
plumbness1543133plumbness
plumpness1543473plumpness
politeness1247983politeness
precess11310863pr__ecess
preciseness1545783preciseness
preeners102712813pr_eeners
pretenses112210593pretenses
priestess1145293priestess
primages13159273primage_s
primates121515933primate_s
primeros12336883prime_ros
primers114215673prim__ers
primes104225263prim__e_s
primine113214823primine__
primings13338143primin_gs
primmest14226693prim_mest
primnesses1497803primnesses
primroses1344843primroses
primuses1237083primuse_s
princess12266803pri_ncess
printless1137513printless
prioress1035393pri_oress
priseres10310823prisere_s
prisoners1147373prisoners
prissiness1266133prissiness
privateness1655703privateness
promines123018803promine_s
promptness1643303promptness
propenes122816513propene_s
properness1445923properness
prosiness11311683prosiness
proudness1246693proudness
pureness101110183p_ureness
rareness81112853_rareness
richness1337433_richness
rimless9369363_rim_less
ripeners1036833_ripeners
rudeness938083_rudeness
sameness102712683_sameness
sliminess1137423sliminess
slimness1036523slim_ness
snideness1067683snideness
spruceness1444103spruceness
supremeness1554313supremeness
tameness102411253_tameness
timeless10239543_timeless
trienes74118413tri_ene_s
trigness968403tri_gness
trimeters1139213trimeters
trueness838693tr_ueness
unripeness1245243unripeness
vileness1139983_vileness
whiteness1546483whiteness
wideness12259473_wideness
wiseness112010753_wiseness

Search took 7 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.423422437.4
2DLD Change Limit1486411116.29623608.8
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.76526414.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.