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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

227 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
psis6812034(None) 
apsis75718291apsis
phis95724901phis
pis56362041p_is
piss65033341piss
pois66539041pois
psi56621621psi_
sis37360551_sis
ahis76135382ahis
ais39083582_ais
amis66445322amis
anis45746472anis
aphis105917132aphis
apses76823912apses
arsis55722422arsis
asks85721212asks
aspis74618142aspis
asps65622092asps
ass37844062as_s
axis116127912axis
basis75429862basis
bis56860672_bis
bris65539612bris
chis95933312chis
cis57748042_cis
cris66233432cris
dais57040702dais
dis46459902_dis
diss56434492diss
egis56520652egis
eses45336102eses
ess36030882es_s
ghis85020162ghis
his66359512_his
hiss75629222hiss
ibis66519582ibis
iris45732552iris
is27048222__is
isms66213472isms
iwis77117012iwis
khis117017992khis
kis78051492_kis
kiss85227412kiss
kois85129412kois
kris86423612kris
leis45739602leis
lis37162282_lis
lysis84511462lysis
mis58162632_mis
miss65339432miss
oasis56422552oasis
obis66226842obis
opsin7613472opsin
opsins8411712opsins
oses46641512oses
pacs85842182pacs
padis86227142padis
pads76742962pads
paid75737492paid
paik105726802paik
paiks114719852paiks
pail66141832pail
pails75833062pails
pain65647242pain
pains75138282pains
pair66031512pair
pairs75325832pairs
paisa76021072paisa
paise75028332paise
pals66951352pals
pams85641762pams
pans65855732pans
paps86443452paps
paris75145942paris
pars67560792pars
pas58775742p_as
pases75346502pases
pass65239952pass
pastis84924322pastis
pasts75936502pasts
pats66460852pats
pavis106422732pavis
paws96038182paws
pays95940222pays
peas65755062peas
pecs84634102pecs
peds75835252peds
pees65257372pees
pegs75531762pegs
pehs95625762pehs
pein65834942pein
peins76128062peins
peise75825772peise
penis75129322penis
pens65649642pens
peps85134512peps
peris75537072peris
pes57259782p_es
pesos77221622pesos
pests75933272pests
pets66248332pets
pews95731532pews
phasis114614922phasis
phi86524202phi_
phiz186718842phiz
physis14359662physis
pi48145372p_i_
pia56848042p_ia
pias66542562pias
pic76046832p_ic
pics85633922pics
pie55457412p_ie
pies66949612pies
pig65744982p_ig
pigs76634232pigs
pikis115116392pikis
pilis75825202pilis
pin57066732p_in
pins65558462pins
pip78051052p_ip
pips85837142pips
pish96127922pish
piso66727572piso
pisos76021062pisos
pit56471932p_it
pits66348752pits
piu56639552p_iu
pix126437942p_ix
plie65127392plie
plies74526512plies
plus66324832plus
pods76540162pods
poi57244662poi_
poise75127892poise
polis74731162polis
pols66044562pols
poms87037742poms
pons65850602pons
poos65949112poos
pops86340952pops
poses74642762poses
posies84431432posies
posit75833332posit
posits85718712posits
posts75228782posts
pots66452362pots
pows95537662pows
pries74339532pries
prig75924872prig
prigs85219702prigs
prim85132202prim
prims95425932prims
prise74632612prise
prism94820262prism
priss74623892priss
pros65742782pros
psoas75012982psoas
psst66118402psst
pst57932512ps_t
ptosis83611822ptosis
pubis94616472pubis
pubs85029212pubs
puds75630522puds
pugs76332772pugs
pulis74225602pulis
puls65437562puls
puns66641482puns
pups86032232pups
puris75332022puris
purs65641042purs
pus55547842p_us
puses75532202puses
puss64830132puss
puts65641752puts
pyas96225702pyas
pyes95528992pyes
pyic116915822pyic
pyin96823232pyin
pyins105815862pyins
pyosis114012122pyosis
pyxis17458632pyxis
qis126934392_qis
rais45252622rais
reis45343232reis
seis45542392seis
sepsis83011292sepsis
si29149582_si_
sib56850322_sib
sibs65933552_sibs
sic55847882_sic
sics65234102_sics
sim56553152_sim
sims65737182_sims
sin36265902_sin
sins46755282_sins
sip57656022_sip
sips65740112_sips
sir35746682_sir
sirs44338342_sirs
sit35877762_sit
sits45050212_sits
six105339752_six
skis84825302skis
sos37761602_sos
spas67036722spas
spic85227432spic
spics94123242spics
spies76037622spies
spik105419712spik
spiks114117472spiks
spin66231302spin
spins75327982spins
spit65545082spit
spits74429552spits
spiv95917792spiv
spivs105114242spivs
sris45434152sris
this76027382this
tis37056652_tis
tsks86410662tsks
tuis44829642tuis
uses44931112uses
vis66747622_vis
wis66552342_wis
wiss75630552wiss
xis106935342_xis
ywis105313102ywis

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298722270.87634100.5
3Display Results2272270.0603783.3
 (SQL Overall)1786912271.216146949.8
 
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.