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

295 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
sistra63933(None) 
ristra6310711ristra
bistre83815022bistre
bistro8339942bistro
lustra6358892lustra
mistral91013642mistral
ristras7311562ristras
rostra6310932rostra
sierra637312sierra
siesta639502siest_a
sirra54416322si_rra
sister64421582sister
sisters73721592sisters
sistrum946562sistrum
sitar54820542si_tar
sutra54217932s_utra
vista85416602vist_a
antra56521923_antra
arista6415293arist_a
astral66919283_astral
astray95615543_astray
austral73411513austral
biota74516823biot_a
bister84922763bister
bisters93922613bisters
bistort91216523bistort
bistred103311853bistred
bistres94017213bistres
bistros92810983bistros
centra84113883centra
cesta75419483cest_a
cesura838763cesura
cist67244963cist__
cisted95217523cisted
cistern93310703cistern
cisterna10376363cisterna
cistron9299883cistron
cists76624533cist_s
cistus84611343cistus
citral81113893ci_tral
contra83314703contra
costa75523733cost_a
costar85518613costar
crista8311803crist_a
diastral946993diastral
dicta84915633dict_a
diptera1037213diptera
disarm9310473disarm
disbar938513disbar
dishrag1246273dishrag
distal73615773distal
distil73616433distil
distort81120333distort
distract11313023distract
distrain9412243distrain
distrait9414343distrait
disturb1046233disturb
dita56032523di_t_a
dustrag945363dustrag
elytra934893elytra
estral64716513_estral
estray95713333_estray
extra1239003_extra
fiesta938123fiest_a
fist76248423fist__
fisted104218703fisted
fistic11812573fistic
fists85527543fist_s
fistula1045503fistula
gastral8329553gastral
gastrea847223gastrea
gist56046763gist__
gists66026193gist_s
hijra1535643hi_jra
hist76551543hist__
histed104420243histed
history1339423history
hists86328373hist_s
hosta85917833host_a
infra838643_infra
instar6310013instar
intro54915853_intro
iota45127833_iot_a
isba61310883_is_ba
istle52214713_istle
ixora1236913_ixora
kinara10310373kinara
kishka1232963kishka
kist86540793kist__
kists95822113kist_s
libra74712423li_bra
lira46928683li__ra
list47055343list__
listed74322833listed
listee64223063listee
listel64214743listel
listen64816813listen
lister64527253lister
listeria839433listeria
listers74026533listers
lists56628693list_s
litre55421463li_tre
lustral7339653lustral
lustre64011683lustre
mantra84116093mantra
micra96214973mi_cra
mikra114610313mi_kra
misdraw1345623misdraw
miser75430403miser_
misers85025703misers
misery114113543misery
mist66154533mist__
misted93625823misted
mister84728563mister
misterm114314513misterm
misters93927513misters
mistrace12312643mistrace
mistrain10311943mistrain
mistrals101212623mistrals
mistreat10313113mistreat
mistrial10311383mistrial
mists76633903mist_s
misty106120453mist_y
mitral81314323mi_tral
mitre75522423mi_tre
nitre57519683ni_tre
nitro54914353ni_tro
olestra746173olestra
osetra667423osetra
ossetra744073ossetra
ostia52315583_ostia
pasta76624533past_a
pastry114913033pastry
philtra12103683philtra
piastre9307893piastre
picara10311903picara
pieta75421753piet_a
pinta75727053pint_a
piste75824603pist_e
pistes85325633pistes
pistil83915073pistil
pistol83313333pistol
piston83515923piston
pistou83211843pistou
pita65436433pi_t_a
pitta75018693pi_tta
qintar15359143qintar
riata54618023riat_a
riser55431053riser_
risers64624783risers
rostral7311333rostral
sabra75317853s_abra
sacra74516993s_acra
samara8313853samara
samsara936913samsara
santera7311303santera
sastruga942533sastruga
satara6315533satara
satrap86212553s_atrap
sclera838893sclera
scotia8310803scotia
scuta75815753scut_a
seiser65318343seiser_
seisers73816393seisers
seisor63712343seisor_
seisors73212843seisors
seisure738193seisure
senora63216163senora
sentry92912053sentry
septa75518083sept_a
sera46141393__sera
sestet6826203sestet
sestina72711973sestina
seta45637313s_et_a
shist84829613shist__
shists96515113shist_s
sienna647193sienna
sierran737193sierran
sierras737863sierras
siestas738813siestas
sieur5911893sieur_
sieurs659043sieurs
sifaka1353553sifaka
sift710740663sift__
sifted104313673sifted
sifter94516233sifter
sifters103714793sifters
sifts84918923sift_s
sigla64515203si_gla
sigma84513833si_gma
signa66114703si_gna
signora8348503signora
sika86021323si__ka
siker95326033siker_
silica8311243silica
silt46558193silt__
silted74020013silted
silts55330823silt_s
silty84721633silt_y
silva82714023si_lva
sima64730783si__ma
simar74920813simar_
simars84916933simars
simitar936733simitar
sinistral944683sinistral
sinter63625923sinter
sinters74024083sinters
sir35746673si__r_
sirdar7269103sirdar
sire46150413si__re
sirrah9379753si_rrah
sirras63814863si_rras
sirs44338333si__rs
sis37360543sis___
sisal54217733sis_al
sisals63013573sisals
sises55233833sis_es
siskin1079783siskin
sisses64520603sisses
sissy85812073sis_sy
sistered92612803sistered
sisterly1146333sisterly
sistroid947263sistroid
sistrums1055313sistrums
sit35877753si_t__
sitars65417593sitars
site47052413si_t_e
sited65130743si_ted
sites56045433si_tes
sith75435153si_t_h
sits45050203si_t_s
sitten64113823sitten
sitter63323383sitter
sitters74221553sitters
situp74414063si_tup
situs55019233si_tus
siver85728613siver_
sivers95324153sivers
sixte126216583sixt_e
sixtes133612403sixtes
sixth155512233sixt_h
sixths16416373sixths
sixty154912733sixt_y
sizar145214993sizar_
sizars154812623sizars
sizer145521813sizer_
sizers155215813sizers
softa86415183soft_a
sora45746913__sora
sorta57125413sort_a
spectra11275833spectra
sputa74612963sput_a
star48037763__star
stoa45425913__stoa
strap77925263__strap
straw813321293__straw
stray88525573__stray
stria55723213__stria
sultry938463sultry
supra73614253s_upra
sura45740293__sura
surra55521343s_urra
sutras64818593s_utras
sutta54015333s_utta
synura935983synura
system1135743system
tantra63713353tantra
testa54822043test_a
tetra53417953_tetra
tiara5315913ti_ara
titre54619393ti_tre
ultra539363_ultra
unstrap946783unstrap
vesta86618303vest_a
vestral104111013vestral
vestry1238623vestry
visa76323873vis__a
visard103910123visard
viscera1235083viscera
visor82512833visor_
visors92912223visors
vistas94513273vistas
vita75828523vi_t_a
vitta85015173vi_tta
wastry12388773wastry
wintry12498923wintry
wirra83210823wi_rra
wiser85522803wiser_
wisha114910853wis_ha
wist78049293wist__
wistaria1146623wistaria
wisted104120273wisted
wisteria1147753wisteria
wists86728523wist_s
yantra9449623yantra

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162954.95622743.3
3Display Results2952950.0933172.0
 (SQL Overall)1786912955.42232956.7
 
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.