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

187 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
psi5662162(None) 
phi86524201phi
pi48145361p_i
pis56362031pis
poi57244661poi
psis68120341psis
pst57932511pst
si29149571_si
ahi68040232ahi
ai211288392_ai
ais39083572ais
ami56646812ami
ani37751182ani
apse67725382apse
apsis75718292apsis
as211083072as_
asci66519142asci
ash67944602ash
ask77130702ask
asp57235342asp
ass37844062ass
bi48046472_bi
bis56860662bis
chi86228652chi
cis57748032cis
dis46459892dis
dui46433382dui
es29048222es_
ess36030882ess
ghi77019882ghi
hi57947582_hi
his66359502his
is27048212is_
ism56322382ism
khi106318302khi
ki67537962_ki
kis78051482kis
koi77534752koi
lei36846382lei
li29948752_li
lis37162272lis
mi48249052_mi
mis58162622mis
nisi45823242nisi
obi57127732obi
oi29061482_oi
ops56641252ops_
opsin7613472opsin
os211359882os_
ose38147342ose
pa410456482p_a
pac79054082pac
pad68057322pad
padi76331782padi
pah88853592pah
paid75737482paid
paik105726802paik
pail66141832pail
pain65647242pain
pair66031512pair
pal56761672pal
pam77858392pam
pan58466452pan
pap76758402pap
par57467022par
pas58775742pas
pase65346862pase
pash95638132pash
pass65239952pass
past65959012past
pat58089462pat
paw87651172paw
pax127346852pax
pay88461182pay
pe47649032p_e
pea56657242pea
pec76744412pec
ped66751522ped
pee56066512pee
peg65843062peg
peh86740962peh
pein65834942pein
pen56558842pen
pep76447082pep
per56353092per
peri65636972peri
pes57259782pes
peso66925822peso
pest65555292pest
pet56477302pet
pew86442302pew
pfui9349792pfui
phis95724902phis
phiz186718842phiz
pht86030522pht
pia56848032pia
pic76046822pic
pie55457402pie
pig65744972pig
piki106520562piki
pili66130352pili
pin57066722pin
pip78051042pip
pish96127912pish
piso66727562piso
piss65033332piss
pit56471922pit
piu56639542piu
pix126437932pix
plie65127392plie
ply86323552ply
pod66351482pod
poh86740532poh
pois66539042pois
pol56449382pol
pom78249912pom
poo57757112poo
pop76252252pop
pose66441732pose
posh95427322posh
posit75833332posit
post67953362post
posy96028422posy
pot58078432pot
pow87147282pow
pox126140692pox
prig75924872prig
prim85132202prim
pro55837262pro
pry85728052pry
psoai7469922psoai
psst66118402psst
ptui64912482ptui
pub76037692pub
pud65836652pud
pug65337182pug
pul56138062pul
puli65527622puli
pun58846512pun
pup76339882pup
pur56840552pur
puri65931442puri
pus55547842pus
push95526622push
puss64830132puss
put55759072put
pya87023752pya
pye86432502pye
pyic116915822pyic
pyin96823232pyin
pyx157817012pyx
qi116526902_qi
qis126934382qis
rai37658222rai
rei35647252rei
sei36048932sei
sh56828522_sh
sib56850312_sib
sic55847872_sic
sim56553142_sim
sin36265892_sin
sip57656012_sip
sir35746672_sir
sis37360542_sis
sit35877752_sit
six105339742_six
ski74925692ski
so28855442_so
spa55730812spa
spic85227432spic
spik105419712spik
spin66231302spin
spit65545082spit
spiv95917792spiv
spy86023742spy
sri35634002sri
ti28448292_ti
tis37056642tis
tsk75814732tsk
tui37034022tui
ups55629052ups_
us26937432us_
use36835162use
vis66747612vis
wis66552332wis
xi98128162_xi
xis106935332xis

Search took 1 second 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 Filter178691140840.250714764.0
2DLD Change Limit140841870.37637457.4
3Display Results1871870.0464065.2
 (SQL Overall)1786911870.672265909.2
 
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.