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

246 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
spadix163611(None) 
padi76331782_padi_
padis86227142_padis
radix134414602_radix
sadi55834642s_adi_
sadis64930852s_adis
spade84423322spad_e
spaded103816752spaded
spader94317132spader
spades94222582spades
spading113114382spading
spadixes1834112spadixes
spado83713702spad_o
spahi10311142spahi_
spahis11310382spahis
spail74921552spa_il
spait75631602spa_it
spandex1735832spandex
sparid94016932sparid
spavie113611382spavie
spavin114210652spavin
stadia7312142stadia
adit56443653__adit
admix1557733__admix
cadi75732183_cadi_
cadis84428503_cadis
calix145317353_calix
dyadic1336093dyadic
gadi66329723_gadi_
gadid85517383_gadid
gadis74825293_gadis
gradin83517483gradin
kadi96224833_kadi_
kadis105921063_kadis
khadi1367603khadi_
khadis1446913khadis
nadir61012973_nadir
pad68057323_pad__
paddy125913593_paddy
padle84522343_padle
padre86018163_padre
padri85815173_padri
pads76742953_pad_s
paid75737483_pa_id
paik105726803_pa_ik
pail66141833_pa_il
pain65647243_pa_in
pair66031513_pa_ir
pandit93820753_pandit
panic93923903_panic
pardi85723953_pardi_
pardie96021443_pardie
paris75145943_paris
patin76832853_patin
patio74426353_patio
pavid115717003_pavid
pavin105623203_pavin
pavis106422733_pavis
pax127346853_pa__x
pix126437933_p__ix
podia8415283_podia
pudic104614563_pudic
qadi145621103_qadi_
qadis155917853_qadis
radii64016413_radii
radio64922493_radio
roadie72813813roadie
sabin74924953s_abin
sabir75917003s_abir
sad47459203s_ad__
sade55544473s_ad_e
sades65239893s_ades
sadhe94815133s_adhe
sadhu9459963s_adhu
sadism94113493s_adism
sadist74221353s_adist
sadly94519123s_adly
sahib10314763s_ahib
said55742113s_a_id
saids65328853s_aids
sail45447163s_a_il
sain45551293s_a_in
saki85628483s_aki_
sakis95323673s_akis
salic73424713s_alic
sapid84720933s_apid
sari45444043s_ari_
sarin55239253s_arin
saris54544953s_aris
sasin54626573s_asin
sati45539333s_ati_
satin55935223s_atin
satis55633683s_atis
savin84625083s_avin
sax107447643s_a__x
sayid95516723s_ayid
scad75725773scad__
scads85419963scad_s
scaldic1235943scaldic
scandia1038063scandia
scandic1237003scandic
scudi85112163scudi_
seadog838743seadog
shad86230913shad__
shade95125583shad_e
shaded114518873shaded
shader104218763shader
shades105924533shades
shadier113111153shadier
shadily1437723shadily
shading123115563shading
shadow1337253shadow
shads95124483shad_s
shaduf1337063shaduf
shady125416513shad_y
sharia93116733sharia
sharif122917123sharif
shavie124312423shavie
sialic8313633sialic
sialid7314943sialid
six105339743s___ix
skaldic1443553skaldic
slain54923573sla_in
snail57020203sna_il
sodic84917493s_odic
soldi65717203soldi_
sordid83411163sordid
spa55730813spa___
space95325673spa_ce
spaced114517253spaced
spacer104917793spacer
spaces104722633spaces
spacey136212533spacey
spacial1138763spacial
spacier114011633spacier
spacing123614493spacing
spacy125415623spa_cy
spaders104214473spaders
spadices1336093spadices
spadille1145193spadille
spae65034323spa__e
spaed85522273spa_ed
spaeing103413543spaeing
spaes76029973spa_es
spahee11313443spahee
spails84817823spails
spaits85017473spaits
spake114322743spa_ke
spale74929213spa_le
spales84728103spales
spall74919303spa_ll
spalls84217343spalls
spam85930043spa__m
spams94922193spa_ms
span65234663spa__n
spandril1144093spandril
spang84919733spa_ng
spaniel948923spaniel
spank115919573spa_nk
spanks124514123spanks
spans74528733spa_ns
spar65433303spa__r
spare75135563spa_re
spared95427493spared
sparer84524963sparer
spares84834553spares
sparge94216053sparge
sparids103512123sparids
sparing104823873sparing
spark114920893spa_rk
sparks124616363sparks
sparky154511523sparky
sparoid102311543sparoid
sparry115111303sparry
spars75431543spa_rs
sparse84516343sparse
spas67036723spa__s
spasm94514173spa_sm
spasms10418973spasms
spastic11310383spastic
spat66548523spa__t
spate74731583spa_te
spates85028173spates
spathe115115693spathe
spathic1437543spathic
spatial9310323spatial
spats75031383spa_ts
spavies123012953spavies
spaviet123011933spaviet
spavins12419323spavins
spawn107811713spa_wn
spawns11577923spawns
spay96631663spa__y
spayed124213613spayed
spaying133014623spaying
spays105520513spa_ys
spaz155626163spa__z
spazz155811133spa_zz
specie10412223specie
sped76031493sped__
speil75618643sp_eil
speir75315363sp_eir
sphinx1866203sphinx
sphynx2152613sphynx
spic85227433sp__ic
spider94516803spider
spik105419713sp__ik
spin66231303sp__in
spirit83519923spirit
spit65545083sp__it
spiv95917793sp__iv
split75729013sp_lit
spode84617703spod_e
spodes94817433spodes
spoil75818653sp_oil
sporadic1345053sporadic
sprain83614863sprain
sprig85617743sp_rig
sprit76736403sp_rit
spud75818493spud__
spuds85113673spud_s
sradha1085333sradha
stade64825303stad_e
stades74626243stades
stadias8411113stadias
stadium1038073stadium
staid66722083sta_id
staig65519643sta_ig
stain55727943sta_in
stair54719943sta_ir
stasis63116873stasis
static83118683static
statin63921473statin
studio7247133studio
subfix1835073subfix
suffix1935233suffix
swail86217163swa_il
swain84919053swa_in
swami105614523swami_
swamis114212293swamis
syndic1237303syndic
tsadi6379913tsadi_
tsadis7429133tsadis
varix154313513_varix
wadi86228173_wadi_
wadis95223963_wadis

Search took 7 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 Limit1127162465.76619548.4
3Display Results2462460.0763236.8
 (SQL Overall)1786912466.21528751.6
 
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.