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
salpid9510882salpid
sapid84720932sa_pid
satyrid1137232satyrid
sayed96127142sa_yed
sayids104310972sa_yids
acid77533393_a_cid
acrid86920103_acrid
aid49269083_a__id
alcid85817973_alcid
algid75415583_algid
amid77036353_a_mid
aphid115515393_aphid
arid57642713_a_rid
aroid65428343_aroid
avid88325963_a_vid
avoid95516683_avoid
ayin76331743_a_yin
bayard124411663bayard
bayed115423023ba_yed
caid77837533ca__id
candid104517853candid
canid85526343ca_nid
capsid11312413capsid
cyanid123912043cyanid
daybed13438673daybed
daylit10512493daylit
dayside1236173dayside
fayed126422153fa_yed
gadid85517383ga_did
gadoid9310463gadoid
ganoid8314443ganoid
halid94424983ha_lid
haloid104317763haloid
hayed125822013ha_yed
hayride1437323hayride
hyoid12612443_hyoid
jassid1467223jassid
jaybird2043123jaybird
katydid1642603katydid
kayoed14416903kayoed
laid56439143la__id
layed95127383la_yed
layin84720333la_yin
maid75537663ma__id
mantid93820383mantid
masjid16187323masjid
maybird1543993maybird
mayed115522403ma_yed
mayvin1436523mayvin
myoid11512993_myoid
mysid11610693_mysid
navaid1037653navaid
naysaid1145313naysaid
paid75737483pa__id
pallid93915283pallid
pavid115717003pa_vid
payed115925933pa_yed
paynim1337363paynim
pyoid11513763_pyoid
qaid146023843qa__id
rabid84520783ra_bid
raid55243073ra__id
rancid9513863rancid
ranid66429333ra_nid
rapid86422033ra_pid
rayed95127503ra_yed
sabbed114518083sabbed
sabed86526813sa_bed
sabin74924953sa_bin
sabir75917003sa_bir
sabred95916533sabred
sacked135525213sacked
sacred94917103sacred
sad47459203sa___d
sadi55834643sa_di_
sadis64930853sa_dis
sagged94120013sagged
sagy85327083sagy__
sahib10314763sa_hib
saids65328853sa__ids
sail45447163sa__il
sailed74327763sailed
saimin8313663saimin
sain45551293sa__in
sained75424243sained
saki85628483sa_ki_
sakis95323673sa_kis
salad65321833sa_lad
salic73424713sa_lic
sallied83316953sallied
salmi7815863salmi_
salmis8514273salmis
salpids1038193salpids
salted74121203salted
saltie63422433saltie
salved103916423salved
salvia93310753salvia
samoyed1335893samoyed
sand55338473sa__nd
sanded84920613sanded
saned65636273sa_ned
santir6315253santir
sapped114422013sapped
sarcoid10310453sarcoid
sard55344243sa__rd
sari45444043sa_ri_
sarin55239253sa_rin
saris54544953sa_ris
sarod65325873sa_rod
sashed105622943sashed
sasin54626573sa_sin
sassed76116173sassed
sated66238533sa_ted
sati45539333sa_ti_
satin55935223sa_tin
satis55633683sa_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
sialid7314943sialid
sialoid8310963sialoid
skid95720933s__kid
skyed13529923s_kyed
skylit1338283skylit
slayed104716223slayed
slid55828983s__lid
sloid64619713s_loid
sloyd9409683sloy_d
solid65025083s_olid
sordid83411163sordid
sparid94016933sparid
sparoid102311543sparoid
spayed124213613spayed
squid154211903s_quid
staid66722083s_taid
stayed104817273stayed
stolid74213183stolid
stupid937593stupid
styed95815483s_tyed
styled105613103styled
styli83911173styli_
styloid1137553styloid
stymie1137623stymie
stymied1335663stymied
sulfid1039063sulfid
swayed133510263swayed
syli74318983s_yli_
sylis84316023s_ylis
synod9610283s_ynod
tabid84418263ta_bid
valid94618393va_lid
vapid115614283va_pid
waylaid1445093waylaid
wayside1435183wayside
yid76640833___yid
zayin174512043za_yin

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.376475242.0
2DLD Change Limit1127161784.90622975.1
3Display Results1781780.0632825.4
 (SQL Overall)1786911785.34533431.4
 
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.