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

139 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
speisses1024569(None) 
speises93813931spei_ses
gneisses933672gneisses
peises84125042_pei_ses
pelisses1048482_pelisses
pisses84525082_p_isses
plisses94411772_plisses
prisses94816712_prisses
seises64026712s_ei_ses
sisses64520602s__isses
speise84614252spei_se_
speiss84311642spei_s_s
spenses92913572spe_nses
swisses10417142s_wisses
asperses104111673aspe_rses
aspises9611643asp_i_ses
assesses737383asse_sses
bekisses1434243bekisses
blesses93812393ble_sses
blisses94911513_blisses
brisses94314313_brisses
cesses84221363_ce_sses
chesses124112633che_sses
cresses94219813cre_sses
cuisses9319883_cuisses
disses75225963__disses
dresses83716173dre_sses
ecesises1037023ecesises
esses56422973__e_sses
fesses94820253_fe_sses
guesses8169373gue_sses
hisses94719353__hisses
jesses135215953_je_sses
kisses104217333__kisses
kumisses1443583kumisses
loesses7310033loe_sses
meioses9310833_meioses
messes84924343_me_sses
metisses1036833metisses
misses85130873__misses
nesses64718323_ne_sses
noesises838503noesises
oyesses1037333oye_sses
passes86030473_p_asses
pavisses13397103pavisses
peases85229473_pe_ases
peise75825773_pei_se_
peised94817683_pei_sed
pelisse967063_pelisse_
penises9318193_penises
pensees9311203_pensees
perishes13313753_perishes
perses85428063_pe_rses
peruses94018163_peruses
pishes114722103_p_ishes
pissed94816933_p_issed
pisser84416383_p_isser
pissers95014753_p_issers
pistes85325633_p_istes
plisse8368403_plisse_
plusses93510693_plusses
poises84226543_poi_ses
posses85128803_p_osses
premisses13288763premisses
presses93523153_presses
prises84133173_pri_ses
prissed103311263_prissed
prissies101712003_prissies
prosses94019513_prosses
puisnes937423_puisnes
pusses84322843_p_usses
reissues845993_reissues
repasses101810373repasses
sasses64124393s__asses
schusses1334213schusses
seeresses939053seeresses
seiches12513813s_eiches
seines65029903s_ei_nes
seise54727853s_ei_se_
seised74218123s_ei_sed
seiser65318343s_ei_ser
seisers73816393s_eisers
seisins73614393s_eisins
seisms84912143s_ei_sms
seisors73212813s_eisors
seisures838273s_eisures
seizes154317533s_ei_zes
semioses10611013semioses
semises93916553s_emises
senses63923943s_e_nses
sepses84515883s_e_pses
shikses14116573s_hikses
sises55233833s__i_ses
sissies73716603s__issies
skepsises1542753skepsises
sneeshes1136513sneeshes
speciates13229233speciates
species11314133spe_cies
specifies1647573specifies
speckles16268133speckles
spectres12268683spectres
speeches1537413speeches
speiled104412123spei_led
speils84116223spei__ls
speired103811103spei_red
speirs85013233spei__rs
speltzes1943993speltzes
spences113413923spe_nces
spense83912433spe_nse_
sphinges14267483sphinges
sphinxes20334403sphinxes
spices104326033sp_i_ces
spies76037623sp_i__es
spikes124520713sp_i_kes
spiles84227913sp_i_les
spines85132033sp_i_nes
spires84628113sp_i_res
spites84127333sp_i_tes
spitzes1849173sp_itzes
splashes1337503splashes
splices113914383spli_ces
splines94718893spli_nes
sploshes1336133sploshes
spouses92912813sp_ouses
springes114014033springes
sprites94220333spri_tes
spritzes1946933spritzes
squishes20198383squishes
stenoses8310443stenoses
strasses81311433strasses
stresses81112493stresses
susses64221053s__usses
swishes133411373s_wishes
synesises1245613synesises
tresses73719543tre_sses
uprises92012733upri_ses
uptosses1043973uptosses
wisses94619603__wisses
yesses93615813_ye_sses

Search took 10 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.1561145455.1
2DLD Change Limit1461621398.84316528.6
3Display Results1391390.0632206.3
 (SQL Overall)1786911399.06219718.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.