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

182 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
petsais93843(None) 
petsai838081petsai_
jetsams16124102jetsams
petals84719812pet_als
petasos948602petasos
petasus946362petasus
petnaps1145032petnaps
pitsaws1234992pitsaws
assais6711963_assais
betas75528763bet_a_s
betrays12127823betrays
bettas84913923betta_s
cestas85018543cesta_s
destain8412083destain
destains9311813destains
detail74516433det_ail
details84214043det_ails
detain74617383det_ain
detains83716093det_ains
detrain8412253detrain
detrains9411753detrains
ectasis9249613ectasis
entasis73012573entasis
epitasis1047433epitasis
essays965653_essays
etas46432273_et_a_s
etnas54713933_etna_s
etuis54013133_et_uis
fetas85624403fet_a_s
fetialis11358663fetialis
fetials103711743fetials
fretsaws1442763fretsaws
getas65421483get_a_s
hetmans12187593hetmans
jetlags1533863jetlags
jetsam15116323jetsa_m
jetsoms16124723jetsoms
jetways2094053jetways
ketosis11429733ketosis
lethals1038113lethals
matsahs1236563matsahs
mensas85115853mensa_s
mesas76823203me_sa_s
messans92710463messans
metals84520883met_als
meticais1248183meticais
metis75025903met__is
outsaid81210923outsaid
outsail71411413outsail
outsails8139863outsails
outsays102710403outsays
paesans93312693paesans
paisans93614753paisans
paisas84317493paisa_s
palais8420423p_alais
pastas85422873pasta_s
pastis84924323p_astis
patois84319363pat_ois
patsies93919483patsies
peags86122843pe__ags
peaks114825623pe__aks
peals75235493pe__als
peans75437643pe__ans
pears75138613pe__ars
peas65755063pe__a_s
peasant9314923peasant
peasants1038263peasants
peases85229473peas_es
peats76140193pe__ats
pecans101515833pe_cans
peccavis1743113peccavis
pechans14810503pechans
pectases122411183pectases
pedals94316033pe_dals
pedlars103210213pedlars
peises84125043peis_es
pekans121710553pe_kans
peltasts1035703peltasts
pelvis113610323pe_lvis
penis75129323pe__nis
pennis84315743pe_nnis
pensees9311203pensees
pensil83013333pens_il
pensils92811593pensils
pentads1039523pentads
pentosans1145173pentosans
pepsin10310853peps_in
pepsins11310433pepsins
perhaps1446123perhaps
peris75537073pe__ris
persalt9315413persalt
persalts1038193persalts
perses85428063pers_es
persist9315853pers_ist
persons93717003persons
pertain92714963pertain
pertains102113413pertains
pertussis1143323pertussis
perusals1047143perusals
pesade9311103pe_sade
pesades10310893pe_sades
pesos77221623pe_s_os
pessaries11108653pessaries
pessary1246873pessary
pesters93827093pesters
pestles93217693pestles
pestos84719083pe_stos
pests75933273pe_s_ts
petal76526893pet_a_l
petard95013803pet_ard
petards104311153petards
peters86624593pet_ers
petit74332653pet__it
petites93820203petites
petnap1037423petna_p
petrale9312623petrale
petrales10312953petrales
petrels9279373petrels
petrols92913083petrols
petrous92714423petrous
pets66248333pet___s
petters93722363petters
petti75119453pet_ti_
pettish1238283pet_tish
pettles93916483pettles
petunia966803petunia
petunias1066013petunias
peytrals1355493peytrals
phasis114614923phas_is
physis14359663phys_is
pietas84516503piet_a_s
pitas77427673pit_a_s
pitmans11188743pitmans
pitsaw1135613pitsa_w
pittas86014523pitta_s
postals93716373postals
potsie83916023pots_ie
potsies93019483potsies
pretrain10310923pretrain
pretrains11410143pretrains
prosaic11311163prosaic
prosaism1268043prosaism
prosaist10611583prosaist
protasis102411973protasis
psis68120343p__s_is
ptisans9317363ptisans
ptosis83611823p_tosis
pulsars9358913pulsars
pyosis114012123pyos_is
resaid74517083re_said
resail64418733re_sail
resails74616743re_sails
resaws93713513re_saws
resays93714153re_says
retags73414303ret_ags
retail65522073ret_ail
retails74718973ret_ails
retain64523283ret_ain
retains74522253ret_ains
reteams9339563reteams
retears72814923retears
retrain7615423retrain
retrains8314523retrains
seesaws1034703seesaws
senseis73310643senseis
sepsis83011293seps_is
serais64326133se_rais
stasis63116873_stasis
tatsois748373tatsois
terais64023503te_rais
testis64916713te_stis
tetrads82910173tetrads
tetras63017613tetra_s
tetris62816293tet_ris
tsadis7429133__tsadis
tsars56717103__tsars
vestals104612333vestals
vestas95916683vesta_s
wetsuit1045453wetsuit
wetsuits1143233wetsuits
yetis85418393yet__is
zetas145018163zet_a_s

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.1561145455.1
2DLD Change Limit1340271828.25016245.7
3Display Results1821820.0762394.7
 (SQL Overall)1786911828.48221067.1
 
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.