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

178 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
sayyid1318535(None) 
saiyid10167411saiyid
sayid95516721sa_yid
sayyids14193831sayyids
said55742112sa__id
saiyids11174892saiyids
salpid9510872salpid
sapid84720932sa_pid
satyrid1137232satyrid
sayed96127142sa_yed
sayids104310972sa_yids
acid77533393_a_cid
acrid86920103_acrid
aid49269073_a__id
alcid85817963_alcid
algid75415573_algid
amid77036333_a_mid
aphid115515393_aphid
arid57642713_a_rid
aroid65428333_aroid
avid88325963_a_vid
avoid95516673_avoid
ayin76331743_a_yin
bayard124411663bayard
bayed115423023ba_yed
caid77837533ca__id
candid104517853candid
canid85526343ca_nid
capsid11312413capsid
cyanid123912033cyanid
daybed13438673daybed
daylit10512493daylit
dayside1236173dayside
fayed126422153fa_yed
gadid85517373ga_did
gadoid9310443gadoid
ganoid8314433ganoid
halid94424973ha_lid
haloid104317753haloid
hayed125822013ha_yed
hayride1437323hayride
hyoid12612423_hyoid
jassid1467223jassid
jaybird2043123jaybird
katydid1642593katydid
kayoed14416903kayoed
laid56439143la__id
layed95127383la_yed
layin84720333la_yin
maid75537633ma__id
mantid93820373mantid
masjid16187313masjid
maybird1543993maybird
mayed115522403ma_yed
mayvin1436523mayvin
myoid11512983_myoid
mysid11610683_mysid
navaid1037643navaid
naysaid1145303naysaid
paid75737483pa__id
pallid93915273pallid
pavid115717003pa_vid
payed115925933pa_yed
paynim1337363paynim
pyoid11513753_pyoid
qaid146023843qa__id
rabid84520773ra_bid
raid55243073ra__id
rancid9513863rancid
ranid66429333ra_nid
rapid86422033ra_pid
rayed95127503ra_yed
sabbed114518083sabbed
sabed86526813sa_bed
sabin74924943sa_bin
sabir75916993sa_bir
sabred95916533sabred
sacked135525213sacked
sacred94917103sacred
sad47459203sa___d
sadi55834643sa_di_
sadis64930853sa_dis
sagged94120003sagged
sagy85327083sagy__
sahib10314753sa_hib
saids65328853sa__ids
sail45447163sa__il
sailed74327763sailed
saimin8313663saimin
sain45551293sa__in
sained75424243sained
saki85628473sa_ki_
sakis95323663sa_kis
salad65321833sa_lad
salic73424713sa_lic
sallied83316953sallied
salmi7815863salmi_
salmis8514273salmis
salpids1038193salpids
salted74121203salted
saltie63422423saltie
salved103916423salved
salvia93310753salvia
samoyed1335893samoyed
sand55338463sa__nd
sanded84920613sanded
saned65636273sa_ned
santir6315243santir
sapped114422013sapped
sarcoid10310453sarcoid
sard55344243sa__rd
sari45444043sa_ri_
sarin55239253sa_rin
saris54544953sa_ris
sarod65325873sa_rod
sashed105622943sashed
sasin54626573sa_sin
sassed76116173sassed
sated66238533sa_ted
sati45539323sa_ti_
satin55935213sa_tin
satis55633673sa_tis
satyr848483saty_r
satyric1237493satyric
satyrids1245623satyrids
satyrs937963satyrs
sauced93913303sauced
sauted74119603sauted
saved95127113sa_ved
savin84625083sa_vin
savvied1433803savvied
sawed95628403sa_wed
sawyer12438043sawyer
say67264763sa_y__
sayeds10469253sayeds
sayer84926553sa_yer
sayers94221593sayers
sayest94217743sayest
saying104325543saying
says75942103sa_y_s
sayst85322003sa_yst
sialid7314933sialid
sialoid8310953sialoid
skid95720913s__kid
skyed13529923s_kyed
skylit1338273skylit
slayed104716223slayed
slid55828983s__lid
sloid64619693s_loid
sloyd9409683sloy_d
solid65025073s_olid
sordid83411153sordid
sparid94016933sparid
sparoid102311533sparoid
spayed124213613spayed
squid154211903s_quid
staid66722073s_taid
stayed104817273stayed
stolid74213173stolid
stupid937593stupid
styed95815483s_tyed
styled105613103styled
styli83911173styli_
styloid1137543styloid
stymie1137623stymie
stymied1335653stymied
sulfid1039063sulfid
swayed133510263swayed
syli74318983s_yli_
sylis84316023s_ylis
synod9610283s_ynod
tabid84418253ta_bid
valid94618383va_lid
vapid115614283va_pid
waylaid1445083waylaid
wayside1435183wayside
yid76640823___yid
zayin174512043za_yin

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.1231452772.4
2DLD Change Limit1127161786.14018357.7
3Display Results1781780.0463869.6
 (SQL Overall)1786911786.30928323.2
 
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.