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 “prisses” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
prisses9481671(None) 
brisses94314311brisses
pisses84525081p_isses
plisses94411771plisses
presses93523151presses
prises84133171pri_ses
prissed103311261prissed
prissies101712001prissies
prosses94019511prosses
arises65233802ari_ses
blisses94911512blisses
brasses93818352brasses
brises84927612bri_ses
cresses94219812cresses
crises84529432cri_ses
crosses94220802crosses
cuisses9319882cuisses
disses75225962_disses
dresses83716172dresses
drosses84513822drosses
frasses104314512frasses
frisees104411692frisees
frises94124272fri_ses
grasses84117342grasses
grilses8319152grilses
grosses84517682grosses
hisses94719352_hisses
irises64221172iri_ses
kisses104217332_kisses
krises105016082kri_ses
misses85130872_misses
parises94827192pari_ses
parishes13314762parishes
passes86030472p_asses
pavisses13397102pavisses
peises84125042pei_ses
pelisses1048482pelisses
perishes13313752perishes
pishes114722102p_ishes
pissed94816932p_issed
pisser84416382p_isser
pissers95014752p_issers
pistes85325632p_istes
plisse8368402plisse_
plusses93510692plusses
poises84226542poi_ses
posses85128802p_osses
praises94121112praises
prases84429022pr_ases
premisses13288762premisses
pressed103317312pressed
presser93717622presser
pressers103215022pressers
prices104524542pri_ces
prides94324182pri_des
pries74339532pri__es
priests93810862priests
primes104225262pri_mes
primuses1237082primuses
princes113015152princes
prise74632612pri_se_
prised94322202pri_sed
priseres10310822priseres
prisms104915502pri_sms
prisons9313222prisons
priss74623892pri_s_s
prissier10157872prissier
prissiest11178902prissiest
prissy11347852priss_y
privies122414262privies
prizes173819812pri_zes
proses84733472pr_oses
prossies101515232prossies
puisnes937422puisnes
pusses84322842p_usses
rinses64720382_rinses
rises55244042_ri_ses
risuses73210922_risuses
sisses64520602_sisses
speisses10245692speisses
swisses10417142swisses
trasses74819322trasses
tresses73719542tresses
trioses75015652trioses
trusses73813642trusses
uprises92012732upri_ses
wisses94619602_wisses
wrasses103812592wrasses

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit107671883.17033965.6
3Display Results88880.0302933.3
 (SQL Overall)178691883.57649969.5
 
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.