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

110 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
sayyids1419383(None) 
saiyids11174891saiyids
sayids104310971sa_yids
sayyid13185351sayyid_
saids65328852sa__ids
saiyid10167412saiyid_
salpids1038192salpids
satyrids1245622satyrids
sayeds10469252sa_yeds
sayid95516722sa_yid_
acids87121003_a_cids
aids57846363_a__ids
alcids94812293_alcids
amids85627513_a_mids
aphids125110843_aphids
aroids75118223_aroids
avoids104410203_avoids
ayins85321613_a_yins
bayards13379683bayards
caids85226423ca__ids
candids113812693candids
canids95118133ca_nids
capsids1239333capsids
cyanids13297933cyanids
daybeds14234473daybeds
dayside1236173dayside
daysides1335963daysides
gadids95611823ga_dids
gadoids1036873gadoids
ganoids939333ganoids
halids104016133ha_lids
haloids113012553haloids
hayride1437323hayride
hayrides1536883hayrides
hyoids1377673_hyoids
jassids1586143jassids
jaybirds2142823jaybirds
katydids1741603katydids
layins93817653la_yins
maids86327143ma__ids
mantids103113623mantids
masjids17175403masjids
maybirds1643323maybirds
mayvins1535323mayvins
mysids1246563_mysids
navaids1134803navaids
paynims1434973paynims
qaids156116313qa__ids
raids65827513ra__ids
ranids75118703ra_nids
rapids94913893ra_pids
sabins85521983sa_bins
sabirs85414633sa_birs
sadis64930853sa_di_s
sahibs1137083sa_hibs
said55742113sa__id_
sails55738103sa__ils
saimins9312113saimins
sains55639973sa__ins
sakis95323673sa_ki_s
salads75316963sa_lads
sallies73227813sallies
salmis8514273salmi_s
salpid9510883salpid_
salties73725773salties
salvias10279933salvias
samoyeds1442663samoyeds
sands65228583sa__nds
sanies63031953sa_nies
santims9312603santims
santirs7312963santirs
sapid84720933sa_pid_
sarcoids1137803sarcoids
sardius839553sardius
sards64736183sa__rds
sarins63932623sa_rins
saris54544953sa_ri_s
sarods74918573sa_rods
sasins64923103sa_sins
sassies74719263sassies
satins64930483sa_tins
satis55633683sa_ti_s
satyrid1137233satyrid_
satyrs937963saty_rs
sauries72821623sauries
savins93923133sa_vins
savvies1337603savvies
sawyers13317533sawyers
sayed96127143sa_yed_
sayers94221593sa_yers
saying104325543sa_ying
sayings113610833sayings
says75942103sa_y__s
sialids839723sialids
skids104615333s__kids
sloids73712693s_loids
sloyds10346293sloy_ds
solids74116403s_olids
sparids103512123sparids
sparoids11218713sparoids
squids16409803s_quids
stupids1035273stupids
stymies1239213stymies
sulfids1137293sulfids
sylis84316023s_yli_s
synods1077953s_ynods
wayside1435183wayside
waysides1544453waysides
yids85224963___yids
zayins18409713za_yins

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271106.58020368.8
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.03225411.1
 
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.