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

179 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
primsie113754(None) 
premie103617992prem_ie
premise113818552premise
primage12169142primage
primate111516282primate
prime96525602prim__e
primi95017402prim_i_
primine113214822primine
prims95425932prims__
prise74632612pri_s_e
prissier10157872prissier
prissies101712002prissies
promise113415842promise
prossie91812952prossie
ariose64818723arios_e
ariosi64313033ariosi_
arise56436433ari_s_e
brassie93411523brassie
brims94721623brims__
crime94822693crim__e
crimine112413473crimine
crimpier14287323crimpier
crimple13408693crimple
crimson1135643crimson
crisic103611843cri_sic
crisis83716343cri_sis
crummie1336153crummie
flimsier1344133flimsier
flimsies1335783flimsies
frise85322453fri_s_e
frisee94217993fri_see
gimmie11298183_gimmie
gremmie1264383gremmie
grilse7399503grils_e
grimace1255083grimace
grime85021323grim__e
grimier103210433grim_ier
jimmie17376473_jimmie
optimise1255583optimise
paise75028333pai_s_e
peise75825773pei_s_e
perimysia1653463perimysia
phimosis1546193phimosis
piggie103210773p_iggie
pimple123512963p_imple
pinkie124414273p_inkie
pismire1135353p_ismire
piste75824603p_i_ste
pixie145415523p_i_xie
plimsol1143343plimsol
plimsole1243663plimsole
pliskie1394543pliskie
plisse8368403pli_sse
poise75127893poi_s_e
pommie123710503p_ommie
popsie103013053p_opsie
potsie83916033p_otsie
poussie936623poussie
prairie938333prairie
praise84419413prais_e
prams96125513prams__
prase76128753pr_as_e
precise113518173precise
preemie11310563preemie
premade12311443premade
premier113515633prem_ier
premies113823063prem_ies
premised133013193premised
premises123018273premises
premiss113513813premiss
premix173710333prem_ix
premune1138933premune
preppie1058093preppie
prese75228383pr_es_e
preside10715613pr_eside
previse123713793previse
priapi1037923priapi_
priapic1346023priapic
price93725413pri__ce
pricier113313113pri_cier
prickier16368143prickier
prickle153611013prickle
pride84724733pri__de
priedieu1153983priedieu
pries74339533pries__
priest84125423pries_t
priested1138393priested
priests93810863priests
prigs85219703prigs__
prim85132203prim___
prima95019343prim__a
primacies1548453primacies
primacy1635603primacy
primages13159273primages
primal104014623prim_al
primaries13410833primaries
primary1437703primary
primas104418103prim_as
primates121515933primates
primed115118913prim_ed
primely1457723primely
primer105118683prim_er
primero11368923primero
primers114215673primers
primes104225263prim_es
primines123013703primines
priming123417373priming
primitive1646393primitive
primly13439623prim_ly
primmed14388853primmed
primmer134310163primmer
primming15268173primming
primo95017913prim__o
primos104514423prim_os
primp115615923prim__p
primped14479153primped
primping15338893primping
primps124711823prim_ps
primrose1244503primrose
primula1145713primula
primus103712173prim_us
primuses1237083primuses
prince104114763pri_nce
principe1445683principe
priories10312453priories
prised94322203pri_sed
prisere9310943prisere
prises84133173pri_ses
prising103321453pri_sing
prism94820263pri_s_m
prismoid1344983prismoid
prisms104915503pri_sms
prison8514023pri_son
priss74623893pri_s_s
prissed103311263prissed
prisses94816713prisses
prissiest11178903prissiest
prissily1346693prissily
prissing113011453prissing
prissy11347853pri_ssy
pristine10313503pristine
prithee1239933prithee
private121513263private
privier122910453pri_vier
privies122414263pri_vies
prize164718943pri__ze
promine112819443promine
promised133010873promised
promisee122711333promisee
promiser122510673promiser
promises122916763promises
promote11313143promote
proms95426413proms__
prose75835123pr_os_e
prosier93817483pr_osier
prosit85124593pr_osit
prossies101515223prossies
prostie91617743prostie
prussic1144743prussic
puisne856353pui_sne
ramie75027823_ram_ie
remise84221953_remise
rime65138883_rim__e
rimfire1243793_rimfire
rimier83916273_rim_ier
rimose8310593_rimose
rimple103814583_rimple
rims65936303_rims__
rinse54820973_rins_e
rise45945233_ri_s_e
slimsier1085213slimsier
trickie132611033trickie
trims75021473trims__
triose64715383trios_e
trismic1137483trismic
triste63818643tri_ste
uprise82313693upri_s_e
whimsied1743113whimsied
whimsies1635193whimsies

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271796.37621020.5
3Display Results1791790.0632841.3
 (SQL Overall)1786911796.85926052.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.